Need help with formular please!!!

[Buzz Local#30]

I am wanting to get excel to keep track of my gross earnings through out the
year
I have my pages set up but I can not find a formular that will retain
previous amounts and add new amounts to it like a year to date thing but I
work out of all states and want to seporate the gross earnings into the
states that I earned them in

 

[Dave Peterson]

You have a reply at your other post.

I am wanting to get excel to keep track of my gross earnings through out the
year
I have my pages set up but I can not find a formular that will retain
previous amounts and add new amounts to it like a year to date thing but I
work out of all states and want to seporate the gross earnings into the
states that I earned them in

 

[Buzz Local#30]

Ok so far I the responce for my problem has been use the sumif formular
which I have tried and it work some what, but, not completely so I have came
up with this senario to try and help better explain what I am trying to do
if some one can help with this example I have compiled below would be great?
I am sorry if I am confusing everyone but there just seams like there is
away with acomplishing this problem I have?

I worked in Virginia and say I earned $10,000.00 gross income for the months
jan thru march I left VA and went to work in Alabama I earned $3,000.00
gross income for the months apr thru may I then left AL and went back to
virginia and work another month which I earned another $5,000.00
Heres what I get with my formular when I enter in the info like I wrote it
above
each I entered in the amounts that I earned in VA first it totaled up
correct then when I started to enter in the amounts for AL the info for VA
returned $0.00 and the info for AL worked correctly I need for the info I
entered for the first time I worked in VA to stay there and the second time
I worked in VA to be added to the first time in the way it was added the
first time on a weekly basis.
This might have confused every one for bit but I am trying to make as simple
as possible to understand I know there has to be a way I just need help to
figure it out from the more experienced?

 

[Pete_UK]

You need to list your places of work and income in separate rows. For
example:

A B C
1 Jan Virginia $10,000.00
2 Apr Alabama $3,000.00
3 Jun Virginia $5,000.00

and so on. Each time you have a different place of work, you put the
details on a new row. Now in a different part of your worksheet you
can have a summary of your earnings by state. Set it out like this:

E F
1 Alabama
2 Virginia
3 Georgia

and in F1 put this formula:

=SUMIF(B:B,E1,C:C)

Copy this down into F2 and F3 and it should give you $3,000.00 against
Alabama, $15,000.00 for Virginia and 0 for Georgia.

If you have a new contract, then put the details on the next row (4 in
the example), and the formula will automatically include it. If you
work in a different state, put the name in the next free cell in
column E and copy the formula from F2 into the cell in column F. You
can set your summary table up in advance to include all the states
where you think you night be working.

Hope this helps.

Pete

 

[Buzz Local#30]

Ok I understand that
So there is no way of having all that done by using just 1 weekly entry
sheet then?
and as far as the multiposting I do apoligise I am new to this group thing I
just figured the different cummunities did not connect with each other and
it would genorate a better responce it will not happen again sorry to all it
annoys
You need to list your places of work and income in separate rows. For
example:

A B C
1 Jan Virginia $10,000.00
2 Apr Alabama $3,000.00
3 Jun Virginia $5,000.00

and so on. Each time you have a different place of work, you put the
details on a new row. Now in a different part of your worksheet you
can have a summary of your earnings by state. Set it out like this:

E F
1 Alabama
2 Virginia
3 Georgia

and in F1 put this formula:

=SUMIF(B:B,E1,C:C)

Copy this down into F2 and F3 and it should give you $3,000.00 against
Alabama, $15,000.00 for Virginia and 0 for Georgia.

If you have a new contract, then put the details on the next row (4 in
the example), and the formula will automatically include it. If you
work in a different state, put the name in the next free cell in
column E and copy the formula from F2 into the cell in column F. You
can set your summary table up in advance to include all the states
where you think you night be working.

Hope this helps.

Pete

 

[Pete_UK]

Most of the regular contributors read all the groups' postings.

Another bit of "netiquette" is not to send emails to contributors
unless invited to do so - keep all correspondence within the groups so
that all may benefit.

Excel cannot remember what used to be in a cell if you replace it with
something else, so just do it as I showed you, with your work details
(for a year or more) going down the sheet.

Pete

 

[Buzz Local#30]

Tahk You I have worked out that the reply to group meant the conversation
group and not entire colective I have started using this now like I said
thank you for your help I am new to group help thing and so I am sure I will
find out more things on what to and what not to do in here sorry
on the subject though I have started a new WorkBook and will see how it goes
from there I have found a time card sheet I can use for my weekly wage and
have the info I need off of it to be placed where I need it and then I can
just copy the totals to where I need them to alow excell to be able to
remember what it needs to I think this will work for what I want to do
so to sum up all what I said there here what I will be doing
1) At begining of a contract I will fill in the info such as
employer,add,state ect. into the Time card Sheet
2) have the totals like I was doing automaticly entered into another sheet
or the same as it maybe less confusing call it totals for now
3)At the end of the contract manualy copy the Gross Totals, State, and Job
Title over to this new Book call it Year-To-Date for now
Does that make sence
What am mostly in need of is to remember the different job locations inside
each state and which states I have work for mutiple reasons unemployment and
taxs ect. and would like to keep track of how many times I have work at any
one location over a 2 year period
so I am going to close this for now and work on all that will update to let
you know how I get on later
Thank You again for your patient's and help.
Most of the regular contributors read all the groups' postings.

Another bit of "netiquette" is not to send emails to contributors
unless invited to do so - keep all correspondence within the groups so
that all may benefit.

Excel cannot remember what used to be in a cell if you replace it with
something else, so just do it as I showed you, with your work details
(for a year or more) going down the sheet.

Pete