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!

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")

the range SUMIF does not, so you can do it like this:

=SUMIF(A1:D1,">0")+SUMIF(A1:D1,"<0")

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!

And if the cells are non adjacent...?

*** Sent via Developersdex http://www.yqcomputer.com/ ***

Don't just participate in USENET...get rewarded for it!

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

If it is blocks of cells but no pattern, you could always use the summation

sign (+) linking separate sumif formulas.

--

Regards,

Tom Ogilvy

3. Multiline tooltip problem... shows the \n's

4. 2 fields have embedded \n's, how to get rid of these?

5. Weird Problem -- Repeating C's and N's

7. index n's maximun values in an array

10. Is is possible to count the Y/N's in a record?

11. deleting empty lines from a variable containing \n's

12. Mofify data values of n's variables

13. How to change the "N's" in proc report across time

14. Sum sum sum

15. How to perform sum sum sum...

6 post • Page:**1** of **1**