Excel

[Montano]

I would like to get the average of a column of numbers, but I need for the formula to exclude any zeros in the column. How do I write this formula?

 

[straybullet]

If the zeros are in place of "no data" then remove them - the zeroes which are actual data should be included in an average.
Any "blank" cells will not be included in the average even if the cells are included in the range.

 

[KenWright]

=AVERAGE(IF($A$1:$A$100>0,A1:A100))

Array entered using CTRL+SHIFT+ENTER

No need to delete the 0s

Regards
Ken..............

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------