How do I add negative numbers to total and show positive?
D Dave Peterson Mar 23, 2007 #2 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))
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))
