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
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
Add 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!