Hi,
I am doing the formula below and it seems to be working for 1 condition but not for the other 3. Everything is the same in the formula excel the rows that are changing when dragging the formula. Please help.
=IFERROR(MEDIAN(IF($A$7:$A$85=$A90,IF($B$7:$B$85=$B90,D$7:D$85))),0)
Thanks,
JK
Bookmarks