- Need a formula to sum a column with #Value error
- Excel macro formula to sum column
- Sumif formula to sum between 2 dates...help (Solved)
- Sum # in column only if cell contain text (Solved)
- Trying to sum a column that contains various text (Solved)
- A and B column query to provide Sum of column C (Solved)

Try this:

=SUM(SUMIF(I8:I65536,{"<0",">0"}))

=SUM(SUMIF(I8:I65536,{"<0",">0"}))

Was this answer helpful?

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

I really celebrate you, your answer performed the magic. Well done!