Previous Topic Next Topic

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

Answer 1 / 1
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
Thank you

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

CCM 2942 users have said thank you to us this month

Report
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!
Ask a question