Thanks,
I will try it.
"Bernie Deitrick" wrote:
Tina,
Array enter (using Ctrl-Shift-Enter) a formula like:
=MEDIAN(IF($B$2:$B$200=E2,$C$2Â*:$C$200))
That will return the median of numbers in C2:C200 where B2:B200 matched cell
E2.
For AverageIf, use SumIF/CountIF.
HTH,
Bernie
MS Excel MVP
"TinaMo" wrote in message
...
Is there any way to get an AVERAGEIF & MEDIANIF function in Excel?
|