# Subtracting One Sum From Another

1. ## Subtracting One Sum From Another

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

2. ## Re: Subtracting One Sum From Another

Hi. I'm sorry I don't understand the pattern here; is it a typo?
=sum(e5-g4) =sum(g5-e6)
Perhaps you need:
=g4+c5-e5
************
Anne Troy
www.OfficeArticles.com

"R. U. Sirius" <down@thestn.org> wrote in message
news:bqkhj11ekshv05qjgat60h52r7oievr23d@4ax.com...
>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
>
>
>

3. ## Re: Subtracting One Sum From Another

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

R. U. Sirius wrote:
> 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

4. ## Re: Subtracting One Sum From Another

superfluous in your formula just E5-G4 will do what you want.

--
HTH

Sandy
sandymann@mailinator.com
Replace@mailinator with @tiscali.co.uk

"George Gee" <georgegradwell@ntlworld.com> wrote in message
news:%23Dh4WZ4wFHA.3856@tk2msftngp13.phx.gbl...
>
> 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
>
>
> R. U. Sirius wrote:
>> 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

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1