removing zeros from fromulas in excel

E

elarscott

I'm using Excel and trying to do averaging using averaging in the formula
there are zero's with in the infomration that I would like to not be included
in the averaging how can I remove them from the formula?
 
D

Don Guillett

try this average if formula. It is an ARRAY formula so must be entered using
ctrl+shift+enter

=AVERAGE(IF(K1:K4>0,K1:K4))
 
G

Gary's Student

If you have zeros in your data that are real (that you want to include in the
average) and other zeros that represent missing data, then replace the "bad"
zeros with blanks. AVERAGE() will not include blanks in its calculation.
 
C

CLR

Instead of the AVERAGE formula, use.....

=SUM(D1:D8)/COUNTIF(D1:D8,">0")

Vaya con Dios,
Chuck, CABGx3
 
Top