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