C1, copied down:

=SUM(SUMIF(A1:B1,{"<0","0"}))


JonR wrote:
Hi

I'm trying to work around some #N/A values in calculations. Columns A and B
are populated with a conditional formula, and I'm trying to sum them in
column C; so data could look like:

A1 = 3, B1 = 4 C1= sum(A1:B1)
A2 = 2, B2 = #N/A C2= sum(A2:B2)

I would like to have C2 = 2, disregarding the #N/A, but can't seem to do it.
I need to keep the #N/A in the cells in order to have zero values ignored in
some graphs built off this data.

Any hints?

TIA
JonR