Report

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

Ask a question redbaby 11Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Last answered on Mar 21, 2016 11:52AM by redbaby
I need a formula that will sum column i8 to i65536 in cell m7 ignoring #value error. Any help? Thanks.
See more 
Helpful
+1
moins plus
Try this:

=SUM(SUMIF(I8:I65536,{"<0",">0"}))
redbaby 11Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Mar 21, 2016 11:52AM
Dear Nado2oo2,

I really celebrate you, your answer performed the magic. Well done!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!