Need a formula to sum a column with #Value error [Solved/Closed]
redbaby
11
Posts
Monday March 21, 2016Registration date
March 24, 2016
Last seen
-
Mar 21, 2016 at 10:22 AM - Latest reply:
redbaby
11
Posts
Monday March 21, 2016Registration date
March 24, 2016
Last seen
- Mar 21, 2016 at 11:52 AM
- Need a formula to sum a column with #Value error
- Excel macro formula to sum column [Solved] » Forum - Excel
- A and B column query to provide Sum of column C (Solved) » Forum - Excel
- Sumif formula to sum between 2 dates...help (Solved) » Forum - Office Software
- Trying to sum a column that contains various text [Solved] (Solved) » Forum - Excel
- Sum # in column only if cell contain text [Solved] (Solved) » Forum - Office Software
2 replies
Best answer
Try this:
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
has helped 1884 users this month
I really celebrate you, your answer performed the magic. Well done!