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 » Forum - Excel
- Excel formula to compare two columns and return a value (Solved) » Forum - Excel
- Vlookup formula to compare two columns in different sheets » How-To - Excel
- Excel formula to compare two columns and return a value » Forum - Excel
- Compare values in two columns and return the value from third (Solved) » Forum - Excel
2 replies
Best answer
Try this:
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
has helped 1662 users this month
I really celebrate you, your answer performed the magic. Well done!