help in subratcting columns
 

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...

help in subratcting columns
 

so.. in cell E1, you type:

=sum(D1-C1)

"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...

help in subratcting columns
 

=D1-C1 and fill down as necessary.

Dave
--
Brevity is the soul of wit.


"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...

help in subratcting columns
 

.... but you don't need sum()
=D1-C1 will do.
--
David Biddulph

"Sean Timmons" wrote in message
...
so.. in cell E1, you type:

=sum(D1-C1)

"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out
the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D
rows

thanks...

help in subratcting columns
 

is there a way i can do it with one formula and not have to type in c1-d1,
c2-d2, etcc...i have about 100 rows

"Dave F" wrote:

=D1-C1 and fill down as necessary.

Dave
--
Brevity is the soul of wit.


"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...

help in subratcting columns
 

junkgrrl

Place your formula in the first (upper most) column. Move your curser over
the lower right corner of that cell, when the curser becomes a small Plus "+"
sign double click and it should fill to the bottom of you data. If by chance
it does not, when you get the small plus "+" sign click and holdm on it and
drag it to the bottom opf your data.

Does this help

Mike Rogers

"junkgrrl" wrote:

is there a way i can do it with one formula and not have to type in c1-d1,
c2-d2, etcc...i have about 100 rows

"Dave F" wrote:

=D1-C1 and fill down as necessary.

Dave
--
Brevity is the soul of wit.


"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...

help in subratcting columns
 

Type your formula in E1 then double-click on the fill handle(black square at
bottom right of E1)

Formula will be copied down as far as you have data in column D

You could also left-click on the fill handle of E1 and drag/copy down the
column.

There are other methods but this should get you moving.


Gord Dibben MS Excel MVP

On Tue, 2 Jan 2007 11:18:04 -0800, junkgrrl
wrote:

is there a way i can do it with one formula and not have to type in c1-d1,
c2-d2, etcc...i have about 100 rows

"Dave F" wrote:

=D1-C1 and fill down as necessary.

Dave
--
Brevity is the soul of wit.


"junkgrrl" wrote:

I need to subtract two columns in every row...i can't seem to figure out the
formula for it...

ex.
C D
1 1997 2006
2 1954 2003
3 1960 2004 ...ETC... i need to subract all the C rows from the D rows

thanks...