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...

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...

.... 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...

=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...

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...

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...

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...