How to return min, mean, max using criteria?

S

stevenva

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

Bernie Deitrick

Steven,

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

The formulas were tested and worked for me.

HTH,
Bernie
MS Excel MVP
 
Top