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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
array formulas using MIN MAX 3
Calculating Max & Min in a negative numbes 6
Average exluding max and min values 11
Return the column 2
displaying adjacent cell when using max/min formulae 7
How to return min, mean, max using criteria? 1
get max or min number 9

Top