Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
negitive and possitive numbers
I want to add negitive and possitive numbers, but I only want the total of
the value in the three columns ignoring the + or - sign. example (-2) (-3) (4) would equal -1, but I want it to equal 9 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
negitive and possitive numbers
With your values in A1 thru A3, enter:
=SUM(ABS(A1:A3)) This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200851 " wrote: I want to add negitive and possitive numbers, but I only want the total of the value in the three columns ignoring the + or - sign. example (-2) (-3) (4) would equal -1, but I want it to equal 9 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
negitive and possitive numbers
That did help but, the problem I have is the columns I want to us are not
next to each other. It's more like I8,L8 and O8 and the columns in between them have valves that I don't want in the equation. just the three shown above. I tried to replace the : with , but got errors. "Gary''s Student" wrote: With your values in A1 thru A3, enter: =SUM(ABS(A1:A3)) This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200851 " wrote: I want to add negitive and possitive numbers, but I only want the total of the value in the three columns ignoring the + or - sign. example (-2) (-3) (4) would equal -1, but I want it to equal 9 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
negitive and possitive numbers
" wrote:
I want to add negitive and possitive numbers, but I only want the total of the value in the three columns ignoring the + or - sign. example (-2) (-3) (4) would equal -1, but I want it to equal 9 ABS(A1) returns the non-negative value of A1. For example, both ABS(-1) and ABS(1) are 1. So you could write: =abs(A1)+abs(B2)+abs(C3) ----- original message ----- " wrote in message ... I want to add negitive and possitive numbers, but I only want the total of the value in the three columns ignoring the + or - sign. example (-2) (-3) (4) would equal -1, but I want it to equal 9 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
negitive and possitive numbers
=SUM(ABS(I8),ABS(L8),ABS(O8))
-- David Biddulph " wrote in message ... That did help but, the problem I have is the columns I want to us are not next to each other. It's more like I8,L8 and O8 and the columns in between them have valves that I don't want in the equation. just the three shown above. I tried to replace the : with , but got errors. "Gary''s Student" wrote: With your values in A1 thru A3, enter: =SUM(ABS(A1:A3)) This is an array formula that must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200851 " wrote: I want to add negitive and possitive numbers, but I only want the total of the value in the three columns ignoring the + or - sign. example (-2) (-3) (4) would equal -1, but I want it to equal 9 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheet with negitive numbers | Excel Discussion (Misc queries) | |||
How do I convert a column of positive numbers to negitive numbers | Excel Worksheet Functions | |||
how to change a list of possitive numbers to negative | Excel Worksheet Functions | |||
how to change a list of possitive numbers to negative | Excel Worksheet Functions | |||
How do I change numbers from positive to negitive | Excel Worksheet Functions |