| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate average and not include zero values
I have a final issue with my measurements sheet. I have several columns
designed to calculate how long it has taken people to do something ie, lines minutes lines per hr I then have a list of people and at the bottom of this list it then calculates the average no of lines per hr, trouble is it includes any zeroes also in the list, so instead of giving average of say the 2 people who did job it also includes 0 from the other 9? The formula i have at the moment is =SUM(IF(ISNUMBER(E5:E13),E5:E13,0))/COUNT(E5:E13) originally this was due to #DIV/0 issues which have been sorted. if i just use =AVERAGE(E5:E13) i just get the same answer now, can anyone help with my problem please, Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Don't include errors in average | Excel Worksheet Functions | |||
| How do I include average costs in my charts? | Charts and Charting in Excel | |||
| Average Function (include Blank Cells and Zeros) | Excel Discussion (Misc queries) | |||
| Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
| in a pivot table, can the average include blank entries? | Excel Discussion (Misc queries) | |||
Threaded Mode
