Formula
How do I add negative numbers to total and show positive?
|
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 |
All times are GMT +1. The time now is 09:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com