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