Greetings-
Trying to calculate median values for a range of numbers that are higher than value in one cell but lower than value in another.
I have the "greater than" criterion but can't figure out how to add the "less than" criterion.
=MEDIAN(IF($D$1188:$D$1847>F1860,$F$1188:$F$1847))
So, calculate the median for values in the range that are greater than F1860 but less than F1861.
Many thanks.
Bookmarks