if so, how do u make a function where it will do it automatically all the way down a column? (for example, if in column F u want the function to be =SUM(D,-E) for each row (function for F2: =SUM(D2,-E2) etc) do u have to keep writing the row number in all the way down or is there a way just to put it in once so that it works the whole way down the column?

Ok this is very simple.

Once you have the your =sum whatever you highlight the colums that you want it to go to. then you go to Edit; Fill; then choose the direction that you need it to fill. I had to do alot of this stuff in computer tech class.

:)

I took MS Excel last year, but if I understand what you're trying to do, you can also use this formula for example ---> SUM=(F2:F10) This will add all of the cells starting from f2 to f10.