Hi
I'm trying to make Column D = B-C, through the whole column.
I tried =SUM(D2=B2-C2) but didn't work
Please help = I am stupid!
2007-07-03 03:52:46 · 4 answers · asked by s g 2 in Computers & Internet ➔ Other - Computers
Put =B1-C1 in D1.
Copy D1 down as far as you wish.
It will convert to relative addresses.
If you want the sum of column D then in the cell after the last put
=SUM(D1:Dx) where x is the last row to add.
2007-07-03 04:05:16 · answer #1 · answered by Barkley Hound 7 · 0⤊ 0⤋
In cell D2, enter the formula =B2-C2
That will make the one cell (D2) equal to B2-C2
Highlight cell D2, and copy it down column D as far as you need it to go.
Each of the cells in D should now contain the "adjusted" formula (D3 will be =B3-C3, D4 will be =B4-C4, etc).
If you want to sum the whole thing at the bottom of the columns, you would want in the last cell the B to sum column B (such as in B25 type =sum(B2:B24). Also sum column C.
Then in column D just use the standard =B25-C25.
When writing a formula, you can not refer to the cell that hold the formula within the formula itself. So cell D2 can not have a formula that includes "D2" as part of the formula.
2007-07-03 11:06:24 · answer #2 · answered by dewcoons 7 · 0⤊ 0⤋
you should just be able to go into column D and type in =B-C and then copy that all the way down.
2007-07-03 11:24:56 · answer #3 · answered by foxysearchk9 1 · 0⤊ 0⤋
click in D2 and type = B2-C2
2007-07-03 10:58:19 · answer #4 · answered by tommy d 5 · 0⤊ 0⤋