sum of cells without #VALUE
 

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.
--
Shooter

One way:

=SUM(C3,E3,G3,I3)

SUM() ignores text.

In article ,
"Shooter" wrote:

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.

Try this

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

"Shooter" wrote:

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.
--
Shooter