Thank you so much - worked beautifully!!

"ShaneDevenshire" wrote:

Hi,

instead of =SUM(A1:A10)

use =SUM(ABS(A1:A10))

Enter this last formula by pressing Shift Ctrl Enter instead of Enter. Or

=SUMPRODUCT(ABS(A1:A10)) this doesn't need Shift Ctrl Enter

Cheers,
Shane Devenshire