averages
Hello T. Valko,
I also tried the Array formula with good results less all 0's. Actually I
changed it slightly to the following due to a consistent +2 error in our
input. Meaning that if we actually have a value of 0 it can sometimes read up
to 2. So below works great until I have all cells between 0 and 2 then I get
the error. Is there a way to say (If not then "") so if all cells are between
0 and 2 leave the formula cell blank.
=AVERAGE(IF(A1:A102,A1:A10))
--
Thank you for your time!
John
"T. Valko" wrote:
Assuming the numbers are always positive...
Try one of these:
=SUM(A1:A10)/COUNTIF(A1:A10,"0")
This one is an array formula** :
=AVERAGE(IF(A1:A100,A1:A10))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
"tommy" wrote in message
...
Hi, I have a column with a line of numbers and I have set an average at
the
bottom using Autosum but it is dividing the zeros as well is there any way
around this?.
Thanks in advance, Barry.
|