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?
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:K4>0,K1:K4))
--
Don Guillett
SalesAid Software
[email protected]
"elarscott" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks