Average without numbers
One way assuming there are no negative numbers:
=SUM(A10:J10)/MAX(1,COUNTIF(A10:J10,"0"))
--
Biff
Microsoft Excel MVP
"Ed Davis" wrote in message
...
How would I get the true Average of cell a10 - j10 if only 4 of the cells
have a number.
Example
A10, B10, f10, all have the number 10 but when I get the average I get 3
as the average and not 10. It should be 10.
Thanks in advance.
|