I am trying to total up my year to date and catagorize the amount by states
but no of the pre formulars seem to be able to do that and I am not sure if
you can or how to combine several formulars together

I have a sheet for my weekly wage info to be entered with a location box for
the state location what i am wanting to do is reference the states location
on my all states sheet and log the gross total from the weekly page and
place in the corrosponding cell on the all state page is this possible


Example

I worked in VA, AL, NC, VA ( notice I place VA in there 2 times I want the
totals for both times to be added together).
Each week I want to enter in my pay slip amounts on the weekly wage page say
for VA I want that info to be calculated and placed on the all state page
under VA.

I tried to use the match formular in combination with the add formular but
it did not work?

Have a look at the SUMIF function in Excel Help - it does exactly what
you want to do with a single condition.

You can also use the SUMPRODUCT function if you have more than one
condition.

Hope this helps.

Pete

On Apr 19, 12:12*am, "Buzz Local#30" wrote:
I am trying to total up my year to date and catagorize the amount by states
but no of the pre formulars seem to be able to do that and I am not sure if
you can or how to combine several formulars together

I have a sheet for my weekly wage info to be entered with a location box for
the state location what i am wanting to do is reference the states location
on my all states sheet and log the gross total *from the weekly page and
place in the corrosponding cell on the all state page is this possible

Example

I worked in VA, AL, NC, VA * ( notice I place VA in there 2 times I want the
totals for both times to be added together).
Each week I want to enter in my pay slip amounts on the weekly wage page say
for VA I want that info to be calculated and placed on the all state page
under VA.

I tried to use the match formular in combination with the add formular but
it did not work?

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" wrote in message
...
Have a look at the SUMIF function in Excel Help - it does exactly what
you want to do with a single condition.

You can also use the SUMPRODUCT function if you have more than one
condition.

Hope this helps.

Pete

On Apr 19, 12:12 am, "Buzz Local#30" wrote:
I am trying to total up my year to date and catagorize the amount by
states
but no of the pre formulars seem to be able to do that and I am not sure
if
you can or how to combine several formulars together

I have a sheet for my weekly wage info to be entered with a location box
for
the state location what i am wanting to do is reference the states
location
on my all states sheet and log the gross total from the weekly page and
place in the corrosponding cell on the all state page is this possible

Example

I worked in VA, AL, NC, VA ( notice I place VA in there 2 times I want the
totals for both times to be added together).
Each week I want to enter in my pay slip amounts on the weekly wage page
say
for VA I want that info to be calculated and placed on the all state page
under VA.

I tried to use the match formular in combination with the add formular but
it did not work?

See answer elsewhere, and please do not multi-post - it wastes both
your and respondents' time, and you may get black-listed.

Pete

On Apr 21, 2:17*pm, "Buzz Local#30" 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 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" wrote in message

...
Have a look at the SUMIF function in Excel Help - it does exactly what
you want to do with a single condition.

You can also use the SUMPRODUCT function if you have more than one
condition.

Hope this helps.

Pete

On Apr 19, 12:12 am, "Buzz Local#30" wrote:



I am trying to total up my year to date and catagorize the amount by
states
but no of the pre formulars seem to be able to do that and I am not sure
if
you can or how to combine several formulars together

I have a sheet for my weekly wage info to be entered with a location box
for
the state location what i am wanting to do is reference the states
location
on my all states sheet and log the gross total from the weekly page and
place in the corrosponding cell on the all state page is this possible

Example

I worked in VA, AL, NC, VA ( notice I place VA in there 2 times I want the
totals for both times to be added together).
Each week I want to enter in my pay slip amounts on the weekly wage page
say
for VA I want that info to be calculated and placed on the all state page
under VA.

I tried to use the match formular in combination with the add formular but
it did not work?- Hide quoted text -

- Show quoted text -