I'm sure this is a stupid question but any help would be appreciated.

Generally I need to add two cells with sum in third cell. Easy enough. But everyonce in awhile I have to put "N/A" in one of the cells. Which then gives me a error in my third cell. Is there a way to tell it If="N/A" then move on?

If it were access I would be fine, but excel just confuses me.

Thanks in advance for your help.

Charmed.

If you enter as text, then the sum should automatically ignore that and still provide the sum (in Excel 2003).
________
Suzuki K15 (http://www.cyclechaos.com/wiki/Suzuki_K15)

I'm using 2003 ed. and I get a #VALUE! error in the calculation field. :(


All I'm writing in the other field is N/A, Any other thoughts?

Charmed

No problem here.

There is not a multiplication or a divide in the chain somewhere because that won't work.

Here is one attached

Yep, exactly how I did mine. No problems with text in the range.
________
M102 ENGINE (http://www.mercedes-wiki.com/wiki/Mercedes-Benz_M102_engine)

The error occurs if you use say =A1+B1 but everything is ok if you use =SUM(A1,B1)

Brian