First of all, try this for your original formula (little shorter):

=IF(F70,(G7+I7*G3)+(H7*I3)/F7,"")

Then, since you say you're not able to total the cells that contain this
formula, I'm guessing that you're *not* using the SUM() function to total
your sheet, but probably using pluses (+) instead (=A1+A2+A3+A4)

Try using SUM()
=SUM(A1:A4)
OR
=SUM(A1,B2,C3,D4)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"robert s" wrote in
message ...

I need a fix for a problem I am having .I have a qoute sheet linked to a
spread sheet with multiple rows of Items bein qouted, when I have data
in the cells everything is dandy,but if I have nothing in the cell for
instance I only use one line on the qoute sheet instead of two or eight
I get a div/o error that stops my totals calculations on the first page
and then transfers it to my customer copy.
origanlcode
(G7+I7*G3)+(H7*I3)/F7
Fix hides error code
=IF(ISERROR((G7+I7*G3)+(H7*I3)/F7),"",(G7+I7*G3)+(H7*I3)/F7)
the dividing by zero I understand because there is no numbers in the
code when not in use ,but I cant seem to come up with a different way
of coding it.The if error fix makes it disapear but I still cant total
my numbers unless all rows have data ,any Ideas?

Thanks
Bob S.


--
robert s
------------------------------------------------------------------------
robert s's Profile:
http://www.excelforum.com/member.php...o&userid=32207
View this thread: http://www.excelforum.com/showthread...hreadid=523396