Depends on what you mean.

With this in A1:A5:

-1
2
-3
4
-5

What do you want to see?

To see use this formula
-3 =sum(a1:a5)
3 =abs(sum(a1:a5))
0 =max(0,sum(a1:a5))
15 =sumproduct(abs(a1:a5))





TJ wrote:

How do I add negative numbers to total and show positive?

--

Dave Peterson