K
Ken
How do average a colum of numbers? I will ignore the $0 number.
Thank you very much!
Thank you very much!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
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.
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.
D
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
T
Teethless mama
=AVERAGE(IF(A1:A6<>0,A1:A6))
ctrl+shift+enter, not just enter
ctrl+shift+enter, not just enter
T
Teethless mama
Non array formula
=SUM(A1:A6)/COUNTIF(A1:A6,"<>0")
Just press enter
=SUM(A1:A6)/COUNTIF(A1:A6,"<>0")
Just press enter