Calculating median value if meets condition

**ranmyaku** · 02-05-2012, 02:48 AM

Hi I am kind of new to using excel and have tried to google search and use formulas people have suggested but cannot seem to get this to work. Any help would be appreciated.

I need to calculate the median of a column G which is called Isolation (hrs). I would like to only calculate the median of the numbers whose corresponding column BB indicated that they were 'Guideline compliant.' The values in column BB is either a 0 (indicating non-compliance) or a 1 (indicated compliance).

Thanks in advance.

**ranmyaku** · 02-05-2012, 03:32 AM

Here is a test file.

**JieJenn** · 02-05-2012, 03:41 AM

=MEDIAN(IF(BB2:BB74=1,G2:G74)) enter with Ctrl + Shift + Enter since it is an array formula

**dilipandey** · 02-05-2012, 03:49 AM

Hi Ranmyaku,

You can use the following array formula:-

{=MEDIAN(IF($BB$2:$BB$74=1,$G$2:$G$74,""))}

Above is array formula and need to entered with Ctrl + Shift + Enter key combination. Sample file is also attached. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>