How to return min, mean, max using criteria?
 

The formula for calculating the mean works; however the "min" formula
returns "0", and the "max" formula returns the maximum value in the
entire list, not the maximum value for a specific item in the list.
Possible tweaks to the formulas?


--
stevenva
------------------------------------------------------------------------
stevenva's Profile: http://www.excelforum.com/member.php...o&userid=16100
View this thread: http://www.excelforum.com/showthread...hreadid=275496

Steven,

Did you array enter those formulas, using Ctrl-Chift-Enter?

The formulas were tested and worked for me.

HTH,
Bernie
MS Excel MVP

"stevenva" wrote in message
...

The formula for calculating the mean works; however the "min" formula
returns "0", and the "max" formula returns the maximum value in the
entire list, not the maximum value for a specific item in the list.
Possible tweaks to the formulas?


--
stevenva
------------------------------------------------------------------------
stevenva's Profile:
http://www.excelforum.com/member.php...o&userid=16100
View this thread: http://www.excelforum.com/showthread...hreadid=275496