Posted to microsoft.public.excel.worksheet.functions
|
|
REMOVE THE #DIV/0! ERROR FROM FORMULA WHEN FIGURING MULTIPLE A
Thanks very much for your help. It worked like a charm.
One more if you have the time. Same situation, except I am figuring
averages between 2 numbers.
Simple formula of =U20/T20
Any help would be appreciated.
"David Biddulph" wrote:
=IF(COUNT(D33,G33,J33,M33,P33,S33,V33,Y33),AVERAGE (D33,G33,J33,M33,P33,S33,V33,Y33),"")
--
David Biddulph
"Security Dave" <Security wrote in message
...
I am trying to formulate a cell to figure averages from cells that have
averages.
My current formula reads
=AVERAGE(D33,G33,J33,M33,P33,S33,V33,Y33)
I am getting the error due to blank cells that have not been filled in
yet.
Any suggestions?
|