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
I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.
Related:
- Need a formula to sum a column with #Value error
- Network error occurred - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Cmos checksum error - Guide
- Credit summation formula - 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!