Average numbers in noncontiguous columns ignoring 0's.
 

I need to average numbers that are not in contiguous columns, and I need to
ignore zeros.

Is this possible?

Average numbers in noncontiguous columns ignoring 0's.
 

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 wrote in message
...
I need to average numbers that are not in contiguous columns, and I need to
ignore zeros.

Is this possible?

Average numbers in noncontiguous columns ignoring 0's.
 

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 wrote in message
...
I need to average numbers that are not in contiguous columns, and I need to
ignore zeros.

Is this possible?