skip 0 average

[Ken]

How do average a colum of numbers? I will ignore the $0 number.

Thank you very much!

 

[T. Valko]

One way...

Try this array formula** :

=AVERAGE(IF(A1:A20<>0,A1:A20))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

 

[Dana DeLouis]

How do average a colum of numbers? I will ignore the $0 number.

Thank you very much!

If you have Excel 2007

=AVERAGEIF(A1:A10,"<>0")


= = = = = = =
HTH :>)
Dana DeLouis

 

[Teethless mama]

=AVERAGE(IF(A1:A6<>0,A1:A6))

ctrl+shift+enter, not just enter

 

[Teethless mama]

Non array formula

=SUM(A1:A6)/COUNTIF(A1:A6,"<>0")

Just press enter