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?