## Summing N/A's

### Summing N/A's

Howdie...

Problem...
A1 =5
b1 = #N/A result of formulae
C1 = 3
D1 = 2
Etc etc.

I need to sum a1 to D1 to get 10
The N/A may be in any one of the cells...

If statement the soln...?

Thanks

D

*** Sent via Developersdex http://www.yqcomputer.com/ ***
Don't just participate in USENET...get rewarded for it!

### Summing N/A's

While the normal SUM() function will error out if there is an error value in
the range SUMIF does not, so you can do it like this:
=SUMIF(A1:D1,">0")+SUMIF(A1:D1,"<0")

### Summing N/A's

Hi
Try SUM(IF(NOT(ISERROR(A1:D1)),A1:D1))

HTH
AMANDA

### Summing N/A's

=SUMIF(D1:D10,"<>#N/A")

might work. (did for me)

--
Regards,
Tom Ogilvy

### Summing N/A's

Thanks Tom!

And if the cells are non adjacent...?

*** Sent via Developersdex http://www.yqcomputer.com/ ***
Don't just participate in USENET...get rewarded for it!

### Summing N/A's

That would be harder. Is there a pattern involved?

If it is blocks of cells but no pattern, you could always use the summation
sign (+) linking separate sumif formulas.

--
Regards,
Tom Ogilvy