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

redbaby 11 Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Mar 21, 2016 at 10:22 AM - Latest reply: redbaby 11 Posts Monday March 21, 2016Registration date March 24, 2016 Last seen
- 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.
See more 

2 replies

Best answer
Nado2oo2 2 Posts Monday March 21, 2016Registration date March 22, 2016 Last seen - Mar 21, 2016 at 11:37 AM
1
Thank you
Try this:

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

Thank you, Nado2oo2 1

Something to say? Add comment

CCM has helped 1884 users this month

redbaby 11 Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Mar 21, 2016 at 11:52 AM
Dear Nado2oo2,

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