View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Security Dave[_2_] Security Dave[_2_] is offline
external usenet poster
 
Posts: 2
Default 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?