Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Need help with formular please!!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Buzz Local#30 - 19 Apr 2008 22:25 GMT
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 - 20 Apr 2008 00:01 GMT
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

Signature

Dave Peterson

Buzz Local#30 - 21 Apr 2008 14:15 GMT
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?

>I am wanting to get excel to keep track of my gross earnings through out
>the
[quoted text clipped - 3 lines]
> work out of all states and want to seporate the gross earnings into the
> states that I earned them in
Pete_UK - 21 Apr 2008 15:20 GMT
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

> 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
[quoted text clipped - 28 lines]
>
> - Show quoted text -
Buzz Local#30 - 21 Apr 2008 15:54 GMT
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

On Apr 21, 2:15 pm, "Buzz Local#30" <ba...@kaycopets.com> wrote:
> 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
[quoted text clipped - 38 lines]
>
> - Show quoted text -
Pete_UK - 21 Apr 2008 16:31 GMT
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

> Ok I understand that
> So there is no way of having all that done by using just 1 weekly entry
[quoted text clipped - 83 lines]
>
> - Show quoted text -
Buzz Local#30 - 21 Apr 2008 17:14 GMT
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

On Apr 21, 3:54 pm, "Buzz Local#30" <ba...@kaycopets.com> wrote:
> Ok I understand that
> So there is no way of having all that done by using just 1 weekly entry
[quoted text clipped - 94 lines]
>
> - Show quoted text -

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.