Summing cells, but need to skip when not numerical value

[Charmed7]

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.

 

[shades]

If you enter as text, then the sum should automatically ignore that and still provide the sum (in Excel 2003).
________
Suzuki K15

 

[Charmed7]

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

 

[Mike375]

No problem here.

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

Here is one attached

 

[shades]

Yep, exactly how I did mine. No problems with text in the range.
________
M102 ENGINE

 

[Brianwarnock]

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

Brian