| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN
LOOKING FOR A FORMULA THAT WILL ADD NUMBERS IN A COLUMN, REGARDLESS OF THEIR
SIGN. I DO NOT WANT NEGATIVE NUMBERS TO BE SUBTRACTED. |
|
#2
|
|||
|
|||
|
Try...
=SUMPRODUCT(ABS(A1:A100)) Hope this helps! In article , JON wrote: LOOKING FOR A FORMULA THAT WILL ADD NUMBERS IN A COLUMN, REGARDLESS OF THEIR SIGN. I DO NOT WANT NEGATIVE NUMBERS TO BE SUBTRACTED. |
|
#3
|
|||
|
|||
|
Add a second hidden column the takes the square root of a square....
Or "=ABS(cell) Then in your total cell have in add up that hidden column. "JON" wrote: LOOKING FOR A FORMULA THAT WILL ADD NUMBERS IN A COLUMN, REGARDLESS OF THEIR SIGN. I DO NOT WANT NEGATIVE NUMBERS TO BE SUBTRACTED. |
|
#4
|
|||
|
|||
|
A GREAT BIG THANK YOU.......................
"Domenic" wrote: Try... =SUMPRODUCT(ABS(A1:A100)) Hope this helps! In article , JON wrote: LOOKING FOR A FORMULA THAT WILL ADD NUMBERS IN A COLUMN, REGARDLESS OF THEIR SIGN. I DO NOT WANT NEGATIVE NUMBERS TO BE SUBTRACTED. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple query changing set of numbers from positive to negative | Excel Discussion (Misc queries) | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| Erf (the error function) for both negative and positive numbers | Excel Discussion (Misc queries) | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
Linear Mode
