MEDIAN IF (and AND?) FORMULA

[EMY245]

Hi,

Can anyone help with the correct format for using MEDIAN IF and (I THINK) AND formulas?

Essentially i want to calculate the median based on multiple 'if' statements. I can get it to work for one 'if' but not any more...

{=MEDIAN(IF(A1="10" ............ , $AD:$AD))}

How do i add more IF statements? Or is this not possible?

Thank you!

 

[gaz_chops]

Try

=MEDIAN(IF(A1="10",IF(B1=5,if(C1=2 ............ , $AD:$AD))))

 

[BGY23]

=median(sum(If(And(A1="10",C2="200" etc.......$AD:AD)

It's an array formula so you need ctrl shift and enter altogether to "enter" it and then you see {} et either end.

 

[EMY245]

Thank you! Worked!

 

[BGY23]

You're welcome. Thanks for the feed back