Need a formula to sum a column with #Value error
Solved/Closed
redbaby
Posts
11
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016
-
Mar 21, 2016 at 10:22 AM
redbaby Posts 11 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - Mar 21, 2016 at 11:52 AM
redbaby Posts 11 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - Mar 21, 2016 at 11:52 AM
Related:
- Excel #value error
- Excel sum of column if another column equals ✓ - Forum - Excel
- Formula to match two columns in excel - Guide
- A and B column query to provide Sum of column C ✓ - Forum - Excel
- Sumif formula to sum between 2 dates...help ✓ - Forum - Office Software
- Trying to sum a column that contains various text ✓ - Forum - Excel
1 reply
Nado2oo2
Posts
2
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 22, 2016
1
Mar 21, 2016 at 11:37 AM
Mar 21, 2016 at 11:37 AM
Try this:
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
=SUM(SUMIF(I8:I65536,{"<0",">0"}))
Mar 21, 2016 at 11:52 AM
I really celebrate you, your answer performed the magic. Well done!