Forum Discussion
Solved
Median & Mode with IF conditions AND eliminating blank cells
Attached screenshot. I'm having trouble figuring out how to eliminate the formula from considering blank cells from our attendance on median and mode functions that already have an IF function a...
Confirm the formula for median and mode by pressing Control+Shift+Enter or Command+Enter, to turn it into an array formula.
For median, use formulas such as
=MEDIAN(IF((B2:B49="Monday")*(F2:F49<>""),F2:F49,""))
For mode, use formulas such as
=MODE(IF((B2:B49="Monday")*(F2:F49<>""),F2:F49,""))
Confirm the formula for median and mode by pressing Control+Shift+Enter or Command+Enter, to turn it into an array formula.
For median, use formulas such as
=MEDIAN(IF((B2:B49="Monday")*(F2:F49<>""),F2:F49,""))
For mode, use formulas such as
=MODE(IF((B2:B49="Monday")*(F2:F49<>""),F2:F49,""))