Forum Discussion
Combining AVERAGE, MEDIAN and STDEV with IF functions
I have a rather ragged data set, which is split over three sets of columns. In columns A, H and O I have multiple instances of the same numbers representing sample codes. In the other columns I have ...
Hi Terri,
in line with the approach referred to by Jon, your formulas would be as follows:
Median:
=MEDIAN(IF($M$2:$M$76=$M$78,$N$2:$N$76,""))
STDEV:
=STDEV(IF($M$2:$M$76=$M$78,$N$2:$N$76,""))
You need to array-enter the formulas by activating the formula cell (F2), then pressing 'Ctrl+Shift+Enter'
Yury