skip 0 average
 

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

Thank you very much!

skip 0 average
 

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.

--
Biff
Microsoft Excel MVP


"Ken" wrote in message
...
How do average a colum of numbers? I will ignore the $0 number.

Thank you very much!

skip 0 average
 

On 4/23/2010 5:52 PM, Ken wrote:
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

skip 0 average
 

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

ctrl+shift+enter, not just enter


"Ken" wrote:

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

Thank you very much!

skip 0 average
 

Non array formula

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

Just press enter



"Ken" wrote:

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

Thank you very much!