Need a formula to sum a column with #Value error
Solved/Closed
redbaby
Posts
10
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016
-
Mar 21, 2016 at 10:22 AM
redbaby Posts 10 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - Mar 21, 2016 at 11:52 AM
redbaby Posts 10 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - Mar 21, 2016 at 11:52 AM
Related:
- Need a formula to sum a column with #Value error
- Error network error occurred - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Ps3 error codes - Guide
- Cmos checksum error - Guide
1 response
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!