| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average of a row of numbers not counting 0's
I have a range of numbers, A10:L10, which represents headcounts during
the month. These numbers are a formula, not a manual input. If the month has not occurred yet, the number equals 0. I want to add a formula telling me my average headcount per month. However, because the 0's are included, my average is always understated. Is there a way to calculate the average while ignoring the 0's? I know I can do it by deleting the 0's, but since it is a formula, I prefer not doing that. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average of a row of numbers not counting 0's
=IF(SUM(A10:L10)0,SUMIF(A10:L10,"0")/COUNTIF(A10:L10,"0"),"")
Vaya con Dios, Chuck, CABGx3 "BobS9895" wrote: I have a range of numbers, A10:L10, which represents headcounts during the month. These numbers are a formula, not a manual input. If the month has not occurred yet, the number equals 0. I want to add a formula telling me my average headcount per month. However, because the 0's are included, my average is always understated. Is there a way to calculate the average while ignoring the 0's? I know I can do it by deleting the 0's, but since it is a formula, I prefer not doing that. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average of a row of numbers not counting 0's
BobS9895
Try this =(SUM(A10:L10)/COUNTIF(A10:L10,"<0")) Dave "BobS9895" wrote in message ups.com... I have a range of numbers, A10:L10, which represents headcounts during the month. These numbers are a formula, not a manual input. If the month has not occurred yet, the number equals 0. I want to add a formula telling me my average headcount per month. However, because the 0's are included, my average is always understated. Is there a way to calculate the average while ignoring the 0's? I know I can do it by deleting the 0's, but since it is a formula, I prefer not doing that. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Average of a row of numbers not counting 0's
Thanks to both of you!
Dave wrote: BobS9895 Try this =(SUM(A10:L10)/COUNTIF(A10:L10,"<0")) Dave "BobS9895" wrote in message ups.com... I have a range of numbers, A10:L10, which represents headcounts during the month. These numbers are a formula, not a manual input. If the month has not occurred yet, the number equals 0. I want to add a formula telling me my average headcount per month. However, because the 0's are included, my average is always understated. Is there a way to calculate the average while ignoring the 0's? I know I can do it by deleting the 0's, but since it is a formula, I prefer not doing that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting digits, not numbers | Excel Worksheet Functions | |||
| counting unique numbers in filtered data | Excel Worksheet Functions | |||
| AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
| Counting differences in numbers across columns | Excel Worksheet Functions | |||
| Counting Numbers with Text | Excel Worksheet Functions | |||
Linear Mode
