How many range areas are you trying to sum? Are there only a few or many?
Can you give an example of what you think the formula might look like?

***********
Regards,
Ron

XL2002, WinXP


"LD6892" wrote:

How do I omit a cell that contains a negative number in an addition formula?
I can't use sum because there are cells in between.