Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
How do I add negative numbers to total and show positive?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|