Help!

Trying to create a formula for adding and subtracting colu..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  email signature showing up yellow font - can't se..  
Author Message
teacher206
External


Since: Jan 08, 2010
Posts: 3



PostPosted: Fri Jan 08, 2010 1:04 pm    Post subject: Trying to create a formula for adding and subtracting columns.
Archived from groups: microsoft>public>excel>newusers (more info?)

I have a class that keeps a balance of "money" they earn in school.
Each week we add the total then at the end of the month they subtract thing
s they bought. So I would need a formula that adds the total for four rows
and then subtracts in the fifth row to give me a final total.

I am new to excel and am hoping I will be able to do it without too much
trouble. I am usually a pretty quick learner.
Back to top
Atishoo
External


Since: Feb 20, 2009
Posts: 10



PostPosted: Fri Jan 08, 2010 1:23 pm    Post subject: RE: Trying to create a formula for adding and subtracting columns. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Are you wanting only to make this calculation occur on demand at the end of
the month?

If your happy for it to just calculate as you go along then just use
"=A1+A2+A3+A4-A5" in cell A6.
This is assuming that you have the money they get in a123and4 and the things
they bought in A5 and that you want the total in A6.

If youre after it to occur on demand then this is a bit more complex you
would need to put a command button in off the control toolbox. I can tell you
how to do this if this is what you require?

"teacher206" wrote:

> I have a class that keeps a balance of "money" they earn in school.
> Each week we add the total then at the end of the month they subtract thing
> s they bought. So I would need a formula that adds the total for four rows
> and then subtracts in the fifth row to give me a final total.
>
> I am new to excel and am hoping I will be able to do it without too much
> trouble. I am usually a pretty quick learner.
Back to top
Roger Govier
External


Since: Jan 09, 2009
Posts: 67



PostPosted: Fri Jan 08, 2010 5:10 pm    Post subject: Re: Trying to create a formula for adding and subtracting columns. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi

Assuming your rows 1 to 4 are representing weeks within a month, and each
column is a separate month, then I think you need to change your design, as
some months will have 5 weeks.

With headings in A2:A6 being Earnings Week1, Earnings Week2 ..... Earnings
Week5 and A7 being Expenditure for Month
B1 = January, C1 February etc.
in B8 enter
=SUM(B2:B7)-B7
Drag the formula across the page through cells C8:M8 using the fill handle.
The fill handle is a small black cross that you will see if you hover over
the bottom right corner of cell B8. When you see it, hold down your left
mouse button, drag across though the cells you require, then release the
mouse button and the formulae will be copied across and adjusted to deal
with the relevant columns.
--
Regards
Roger Govier

"teacher206" wrote in message

> I have a class that keeps a balance of "money" they earn in school.
> Each week we add the total then at the end of the month they subtract
> thing
> s they bought. So I would need a formula that adds the total for four
> rows
> and then subtracts in the fifth row to give me a final total.
>
> I am new to excel and am hoping I will be able to do it without too much
> trouble. I am usually a pretty quick learner.
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4754 (20100108) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Back to top
teacher206
External


Since: Jan 08, 2010
Posts: 3



PostPosted: Fri Jan 08, 2010 5:10 pm    Post subject: Re: Trying to create a formula for adding and subtracting columns. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I guess I should have mentioned that in the rows there will be student
names(24 of them) In the columns there will be dates. So this month i will
have 1/8, 1/15, 1/22, 1/29. Each week i fill in the earned money. At the
end of the month they subtract what they want to buy. So in my head the
columns should look like this Smile
B+C+D+E-F=Balance (Assuming that their names are in column A.)

"Roger Govier" wrote:

> Hi
>
> Assuming your rows 1 to 4 are representing weeks within a month, and each
> column is a separate month, then I think you need to change your design, as
> some months will have 5 weeks.
>
> With headings in A2:A6 being Earnings Week1, Earnings Week2 ..... Earnings
> Week5 and A7 being Expenditure for Month
> B1 = January, C1 February etc.
> in B8 enter
> =SUM(B2:B7)-B7
> Drag the formula across the page through cells C8:M8 using the fill handle.
> The fill handle is a small black cross that you will see if you hover over
> the bottom right corner of cell B8. When you see it, hold down your left
> mouse button, drag across though the cells you require, then release the
> mouse button and the formulae will be copied across and adjusted to deal
> with the relevant columns.
> --
> Regards
> Roger Govier
>
> "teacher206" wrote in message
>
> > I have a class that keeps a balance of "money" they earn in school.
> > Each week we add the total then at the end of the month they subtract
> > thing
> > s they bought. So I would need a formula that adds the total for four
> > rows
> > and then subtracts in the fifth row to give me a final total.
> >
> > I am new to excel and am hoping I will be able to do it without too much
> > trouble. I am usually a pretty quick learner.
> >
> > __________ Information from ESET Smart Security, version of virus
> > signature database 4754 (20100108) __________
> >
> > The message was checked by ESET Smart Security.
> >
> > http://www.eset.com
> >
> >
> >
>
> __________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
Back to top
Roger Govier
External


Since: Jan 09, 2009
Posts: 67



PostPosted: Sat Jan 09, 2010 12:10 am    Post subject: Re: Trying to create a formula for adding and subtracting columns. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi

Then swing the formula round. I still believe you will need up to 5 columns
for Income
In H2
=SUM(B2:F2)-G2
Copy down for 24 rows
--
Regards
Roger Govier

"teacher206" wrote in message

> I guess I should have mentioned that in the rows there will be student
> names(24 of them) In the columns there will be dates. So this month i
> will
> have 1/8, 1/15, 1/22, 1/29. Each week i fill in the earned money. At the
> end of the month they subtract what they want to buy. So in my head the
> columns should look like this Smile
> B+C+D+E-F=Balance (Assuming that their names are in column A.)
>
> "Roger Govier" wrote:
>
>> Hi
>>
>> Assuming your rows 1 to 4 are representing weeks within a month, and each
>> column is a separate month, then I think you need to change your design,
>> as
>> some months will have 5 weeks.
>>
>> With headings in A2:A6 being Earnings Week1, Earnings Week2 .....
>> Earnings
>> Week5 and A7 being Expenditure for Month
>> B1 = January, C1 February etc.
>> in B8 enter
>> =SUM(B2:B7)-B7
>> Drag the formula across the page through cells C8:M8 using the fill
>> handle.
>> The fill handle is a small black cross that you will see if you hover
>> over
>> the bottom right corner of cell B8. When you see it, hold down your left
>> mouse button, drag across though the cells you require, then release the
>> mouse button and the formulae will be copied across and adjusted to deal
>> with the relevant columns.
>> --
>> Regards
>> Roger Govier
>>
>> "teacher206" wrote in message
>>
>> > I have a class that keeps a balance of "money" they earn in school.
>> > Each week we add the total then at the end of the month they subtract
>> > thing
>> > s they bought. So I would need a formula that adds the total for four
>> > rows
>> > and then subtracts in the fifth row to give me a final total.
>> >
>> > I am new to excel and am hoping I will be able to do it without too
>> > much
>> > trouble. I am usually a pretty quick learner.
>> >
>> > __________ Information from ESET Smart Security, version of virus
>> > signature database 4754 (20100108) __________
>> >
>> > The message was checked by ESET Smart Security.
>> >
>> > http://www.eset.com
>> >
>> >
>> >
>>
>> __________ Information from ESET Smart Security, version of virus
>> signature database 4754 (20100108) __________
>>
>> The message was checked by ESET Smart Security.
>>
>> http://www.eset.com
>>
>>
>>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4755 (20100108) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum