Prev: spreadsheet
Next: annuity calculation for monthly payments but quarterly compoundin
From: bean counter bean on 15 Apr 2010 16:32
I need to average numbers that are not in contiguous columns, and I need to
ignore zeros.

Is this possible?
From: T. Valko on 15 Apr 2010 17:26
>I need to average numbers that are
>not in contiguous columns

Ok, tell us what columns. Tell us the specific range of cells you need to
average.

>I need to ignore zeros.

Ok, are the numbers to average *always* positive numbers?

>Is this possible?

Probably, just need some more info.

--
Biff
Microsoft Excel MVP


"bean counter" <bean counter(a)discussions.microsoft.com> wrote in message
news:7931B497-924A-486B-8781-20E87F5B225B(a)microsoft.com...
>I need to average numbers that are not in contiguous columns, and I need to
> ignore zeros.
>
> Is this possible?


From: Steve Dunn on 16 Apr 2010 08:23
Something like this:

=SUM($A1:$A20,$C1:$C20,$E1:$E20)/SUMPRODUCT(($A1:$A20<>0)+($C1:$C20<>0)+($E1:$E20<>0))

HTH
Steve.


"bean counter" <bean counter(a)discussions.microsoft.com> wrote in message
news:7931B497-924A-486B-8781-20E87F5B225B(a)microsoft.com...
>I need to average numbers that are not in contiguous columns, and I need to
> ignore zeros.
>
> Is this possible?

 | 
Pages: 1
Prev: spreadsheet
Next: annuity calculation for monthly payments but quarterly compoundin