This formula worked for me (note, expand to fit your range):
=SUMPRODUCT(--(A2:M20),--(MOD(COLUMN(A2:M2),2)=1),(A2:M2))
--
Kevin Vaughn


"LD6892" wrote:

I have 30 columns and need to add every other column, but don't want to
include the cell if it's a negative.
=A2+C2+E2+G2, etc.

Someone else designed the spreadsheet and I was hoping not to have to redo
the whole thing to make it a sum formula.

Thanks

"Ron Coderre" wrote:

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.