#N/A in calculations
in C1: ctrl/shift/enter:
=SUM(IF(ISNA(A1:B1),0,A1:B1))
then fill to C2
Bob Umlas
Excel MVP
"JonR" wrote in message
...
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
|