Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I subtract one column from another?
I am trying to subtract columns in excel to get a third column with totals
automatically without having to subtract each row individually. please help!!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I subtract one column from another?
Assuming data in columns A & B.
In cell C1 type: =A1-B1 With cell C1 selected double-click on the fill handle, lower right of cell. George Gee "jewels" wrote in message ... I am trying to subtract columns in excel to get a third column with totals automatically without having to subtract each row individually. please help!!! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I subtract one column from another?
Numbers in column A
Numbers in column B In C1 enter =A1-B1 Double-click on the fill handle of C1 to copy down. OR maybe you need.......... In C1 enter =SUM(A:A)-SUM(B:B) which will not need copying down. Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 12:58:00 -0700, jewels wrote: I am trying to subtract columns in excel to get a third column with totals automatically without having to subtract each row individually. please help!!! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I subtract one column from another?
if the first column is A and the Second B it will be in coulumn C this
get the formula active by typing =A1-B1 in Cell C1 enter select C1 and grab the right low courner of the cell C1, you should get a solid black cross, left click and hold and drag down, this causes a relative copy of the formula. for mor info and examples go to help files type relative copying. -- Their is always a solution to any problem. "jewels" wrote: I am trying to subtract columns in excel to get a third column with totals automatically without having to subtract each row individually. please help!!! |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I subtract one column from another?
jewels wrote:
I am trying to subtract columns in excel to get a third column with totals automatically without having to subtract each row individually. please help!!! Try this: =SUMPRODUCT((A1:A200)-(B1:B200)) The result is (A1-B1)+(A2-B2)+(A3-B3)+.....+(A200-B200) -- Rodrigo Ferreira Regards from Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBTRACT COLUMN A FROM COLUM B =? | New Users to Excel | |||
Column formulas to subtract value from value | Excel Discussion (Misc queries) | |||
How do I add a column of cells, but IF a row has (), subtract? | Excel Worksheet Functions | |||
HOW DO YOU ADD & SUBTRACT IN ONE COLUMN | Excel Worksheet Functions | |||
subtract 10 from every number in a column | Excel Worksheet Functions |