I have a table of sales data similar to:

Category Item store1sales store2sales etc.
baking mixes Item a 1 3
baking mixes Item b 3 4
baking supplies Item c 2 5
baking supplies Item d 5 6
etc.

This is a table of 500 rows, with a variable number of categories and items each week. I need a subtotal of sales by like category for each store listed. So what I wind up with would look like:

Category Item store1sales store2sales etc.
baking mixes 4 7
baking supplies 7 11
etc.
Total 11 18

These subtotals need to be on a second sheet, as I want the original (the detail) sheet intact for review. So 2nd sheet would have just categories listed with subtotals.

As always, any help would be greatly appreciated!

Denny Behnfeldt