Thank you so much for your input!!! I found the space and all is well now!!!
Sometimes the right information at the right time is all it takes.

"Peo Sjoblom" wrote:

If Debra's formula gives you an error you must have formula blanks or spaces
in the cells when they look empty
there is no way that formula can give an error on empty cells

another way

=SUM(C37:D37,IF(OR(D36="",D35=""),0,D36*D35))

change "" to space if that's what you have

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Mike R" wrote in message
...
Tried your Debras solve and I still have the error without data, entered
data
just to checK it and it does work. Any other ideas

"Biff" wrote:

Hi!

Replace the "" with a zero.

BTW, if your formula returns a #VALUE! error, it's not
working fine. <g

Biff

-----Original Message-----
xl2000
My formula works fine but it has the #value! error. what
do I add to my
formula to rid myself of this?

=IF(C37+D37,C37+D37,"")+D36*D35

Thanks
.