| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Carriage Return in Excel | Excel Discussion (Misc queries) | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
| How to return min, mean, max using criteria? | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
