Need a formula to sum a column with #Value error [Solved/Closed]
redbaby
- Posts
- 11
- Registration date
- Monday March 21, 2016
- Last seen
- March 24, 2016
- Posts
- 11
- Registration date
- Monday March 21, 2016
- Last seen
- March 24, 2016
Related:
- 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 ✓ - Forum - Excel
- Compare values in two columns and return the value from third ✓ - Forum - Excel
- Vlookup formula to compare two columns in different sheets - How-To - Excel
- Need a formula to compare two columns and return a value of 1 - Forum - Excel
1 reply
Best answer
- Posts
- 2
- Registration date
- Monday March 21, 2016
- Last seen
- March 22, 2016
Try this:
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
has helped 1699 users this month
- Posts
- 11
- Registration date
- Monday March 21, 2016
- Last seen
- March 24, 2016
- Mar 21, 2016 at 11:52 AMI really celebrate you, your answer performed the magic. Well done!