Do you mean that 2+(-1) should end up equalling 1, or 3?
Former:
=SUM(B1:B100)
Latter:
=SUM(ABS(B1:B100))
This one must be entered as an array (Use Ctrl+Shift+Enter to confirm formula)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"E2" wrote:

Want to sum all values of column, containing both negative and positive
values. I either receive a "Zero" for a answer or some values are being
ignored.
Any suggestions?
Thanks
Earl