removing zeros from fromulas in excel
 

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?

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

=AVERAGE(IF(K1:K40,K1:K4))

--
Don Guillett
SalesAid Software

"elarscott" wrote in message
...
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?

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.
--
Gary's Student


"elarscott" wrote:

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?

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

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

Vaya con Dios,
Chuck, CABGx3


"elarscott" wrote in message
...
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?