Need a formula to sum a column with #Value error

Solved/Closed
redbaby Posts 11 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - Mar 21, 2016 at 10:22 AM
redbaby Posts 11 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - 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.

1 reply

Nado2oo2 Posts 2 Registration date Monday March 21, 2016 Status Member Last seen March 22, 2016 1
Mar 21, 2016 at 11:37 AM
Try this:

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

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