Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
Hi,
I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
Hi,
How about: =A1-A2-A3 or =200-100-50 Cheers! Jean-Guy "Emanuel Vella" wrote: Hi, I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
Try this
=200 - 100 - 50 =200 - (100 + 50) Sum all memeber except the 1st. then subtracr from 1st member =A1-(sum(A2:A100)) "Emanuel Vella" wrote: Hi, I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
Hi and thanks for the replies.
What I do is, I select for example A1, A2, A3, A4, A5 then I click on formulas / autosum and it writes down automatically the answer in A6. But I can do only the plus, now I want to do this with minus as well! "Joel" wrote in message ... Try this =200 - 100 - 50 =200 - (100 + 50) Sum all memeber except the 1st. then subtracr from 1st member =A1-(sum(A2:A100)) "Emanuel Vella" wrote: Hi, I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
Hi,
Just don't see how that would be possible, consider this, you have 100 in cell A1 and 50 in cell B1, now if you add A1+B1 you get 150, if you add B1+A1 you the same result, not the case when you substract, A1-B1 is 50 while B1-A1 is -50, excel would have no way to determine which number to substract from which number, so the only way I see is to type the formula by hand =A1-B1 or =B1-A1 depending on the result you want. PS..I"m not an expert so this is just my opinion! HTH Jean-Guy "Emanuel Vella" wrote: Hi and thanks for the replies. What I do is, I select for example A1, A2, A3, A4, A5 then I click on formulas / autosum and it writes down automatically the answer in A6. But I can do only the plus, now I want to do this with minus as well! "Joel" wrote in message ... Try this =200 - 100 - 50 =200 - (100 + 50) Sum all memeber except the 1st. then subtracr from 1st member =A1-(sum(A2:A100)) "Emanuel Vella" wrote: Hi, I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
In order to use Autosum for what you want, you'll have to key minus values
into the cells! For example: A1 = 100 A2 = -50 A3 = 25 A4 = -10 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Emanuel Vella" wrote in message ... Hi and thanks for the replies. What I do is, I select for example A1, A2, A3, A4, A5 then I click on formulas / autosum and it writes down automatically the answer in A6. But I can do only the plus, now I want to do this with minus as well! "Joel" wrote in message ... Try this =200 - 100 - 50 =200 - (100 + 50) Sum all memeber except the 1st. then subtracr from 1st member =A1-(sum(A2:A100)) "Emanuel Vella" wrote: Hi, I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
Where should I write them?
"Ragdyer" wrote in message ... In order to use Autosum for what you want, you'll have to key minus values into the cells! For example: A1 = 100 A2 = -50 A3 = 25 A4 = -10 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Emanuel Vella" wrote in message ... Hi and thanks for the replies. What I do is, I select for example A1, A2, A3, A4, A5 then I click on formulas / autosum and it writes down automatically the answer in A6. But I can do only the plus, now I want to do this with minus as well! "Joel" wrote in message ... Try this =200 - 100 - 50 =200 - (100 + 50) Sum all memeber except the 1st. then subtracr from 1st member =A1-(sum(A2:A100)) "Emanuel Vella" wrote: Hi, I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Minus AutoSum
In the appropriate cell(s)!
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Emanuel Vella" wrote in message ... Where should I write them? "Ragdyer" wrote in message ... In order to use Autosum for what you want, you'll have to key minus values into the cells! For example: A1 = 100 A2 = -50 A3 = 25 A4 = -10 -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Emanuel Vella" wrote in message ... Hi and thanks for the replies. What I do is, I select for example A1, A2, A3, A4, A5 then I click on formulas / autosum and it writes down automatically the answer in A6. But I can do only the plus, now I want to do this with minus as well! "Joel" wrote in message ... Try this =200 - 100 - 50 =200 - (100 + 50) Sum all memeber except the 1st. then subtracr from 1st member =A1-(sum(A2:A100)) "Emanuel Vella" wrote: Hi, I know how to select cells and make a plus autosum (ex: 200 + 100 + 100 = 400). But I don't know how to make a minus autosum. (ex: 200 - 100 - 50 = 50). Any help please? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoSum Help | Excel Worksheet Functions | |||
AutoSum | Excel Worksheet Functions | |||
AutoSum | Excel Worksheet Functions | |||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
Autosum box too big | Excel Worksheet Functions |