sum of cells without #VALUE

[Shooter]

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

[JE McGimpsey]

One way:

=SUM(C3,E3,G3,I3)

SUM() ignores text.

In article <D8C19CDA-D527-4920-BEE3-E6B36AF8064F@microsoft.com>,
"Shooter" <Shooter@discussions.microsoft.com> 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.

[Jock W]

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