Subtracting One Sum From Another

  • Thread starter Thread starter R. U. Sirius
  • Start date Start date
R

R. U. Sirius

I have a very simple and basic question, but I'm just learning Excel,
so please bear with me. The situation as follows:

I have a simple spread sheet, columns C, E, and G are input, outgo,
and balance (In that order)

The first four (4) rows are no problem, simple add C to previous G for
Balance.

Then when I go to do output it's basically the same, g5 is G4 minus e5

My question: What is the formula I need enter only once for the
Balance column? Disregard the first four rows. I'm entering each cell
individually =sum(e5-g4) =sum(g5-e6) etc. It really is a bummer
entering all the individual cell formulae.

I appreciate any assistance, and I apologize for the length of the
post. Again, I'm just learning.

BTW: For those who answer questions with a standard "RTFM", I don't
have TFM.

TIA
 
Select the cell in which you have the formula: =sum(e5-g4)
Move your cursor to the bottom right of the cell, and it will
become a black cross, when it is a black cross, left-click and drag
the cursor down the column as far as you want the formula copied.

This is called copying down.

Hope this is what you require.

George Gee
 
In addition to George's helpful instructions note that the SUM is
superfluous in your formula just E5-G4 will do what you want.

--
HTH

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Back
Top