Thanks Bernard. My problem with this spreadsheet is that I do want the zero
to count .
However, I can see where this formula would be valuable to know and am
saving it :)
Meenie

"Bernard Liengme" wrote:

To average excluding zeros use
=AVERAGE(IF(A1:A6<0,A1:A6))
This is an array formula so commit it with SHIFT + CTRL + ENTER not just
ENTER
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Meenie" wrote in message
...
Excel 2003:
When I do an average of a range of cells the 0 is ignored if the numbers
are
in a column and is counted in the average if done across rows. Why is
this?
The numbers are percentages between 0 and 100.
If I have the numbers listed down a column :
100.00%
100.00%
0.00%
85.00%
93.33%
100.00%
The average comes out to 95.67%

If I list them across a row:
100.00% 100.00% 0.00% 85.00% 93.33% 100.00%
the average comes out to 79.72%.

thanks Meenie