sum of cells without #VALUE

[Guest]

I have values in cells C3, E3, G3, I3. I have input "n/a" in cell G3. In cell
K3, I have a formula ( =C3+E3+G3+I3). I am getting a #VALUE error message in
cell K3 because of the n/a value. I would like to add the cells with number
values and ignore the n/a value. I appreciate help with this. Thanks.

 

[JE McGimpsey]

One way:

=SUM(C3,E3,G3,I3)

SUM() ignores text.

 

[Guest]

Try this

=If(G3="n/a",(C3+E3+I3),(C3+E3+G3+I3))