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?