Need a formula to sum a column with #Value error [Solved/Closed]

Report
Posts
11
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016
-
Posts
11
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016
-
I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.

1 reply

Posts
2
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 22, 2016
1
Try this:

=SUM(SUMIF(I8:I65536,{"<0",">0"}))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
11
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016

Dear Nado2oo2,

I really celebrate you, your answer performed the magic. Well done!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!