Hello,
I'm looking for a few different formulas to find the max, min and average for a range.
I have every date from January 1 to December 31 down Column "K" with a list of numbers beside the date in the next column.
I'd like to find the average (excluding zeros), min (excluding zeros) and max for all of the Sundays, Mondays, Etc.
Thanks.
Thanks for the help kersplash!
I was on that page and wasn't able to figure out what "Kutools" was. My version of excel doesn't have that addon.
Do you happen to know the formula...
I'm pretty sure all those links have the formulas. Don't need Kutools.
I had the formula to exclude the zero's but I didn't see the one to pick only a specific day.
I guess i'll keep looking.
Try array entering these two formulas as in the attached.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter. This one formula will return the MIN and MAX in that order. Array enter and fill across.This one array entered returns the AVERAGE.Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
The secret lies in using IF (to exclude 0s) without an Else statement. IF will default to FALSE. Average will ignore those.
Did this help?
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks