Prev: Formula to show entire record on another sheet
Next: pet food bank needs template for organization of customers
From: Ken on 23 Apr 2010 17:52
How do average a colum of numbers? I will ignore the $0 number.

Thank you very much!
From: T. Valko on 23 Apr 2010 18:07
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" <Ken(a)discussions.microsoft.com> wrote in message
news:96DA8155-CCAD-492F-BCAC-D9E426ABE765(a)microsoft.com...
> How do average a colum of numbers? I will ignore the $0 number.
>
> Thank you very much!


From: Dana DeLouis on 23 Apr 2010 18:17
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
From: Teethless mama on 23 Apr 2010 18:26
=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!
From: Teethless mama on 23 Apr 2010 18:28
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!
 | 
Pages: 1
Prev: Formula to show entire record on another sheet
Next: pet food bank needs template for organization of customers