Using Subtotal Feature for multiple Subtotals

[PaulPerger]

I have a set of data which I need to subtotal by State and Type. I have created a much simplified spreadsheet to show data as I receive it, and how I would like to sum that data.

I have used the Sub-total function, but only get either subtotal by State OR Type. I need to Subtotal by Type within each State AND Subtotal by State. I want to use the Subtotal function to add subtotals and have a report similar to the "Desired Look" tab.

I have been able to figure out how to get either all of the "Type" subtotals, OR the "State" subtotals, but haven't been able to figure how to get both.

Needless to say my "Real" data spreadsheet has tens of thousands of lines, thus my desire to not have to this manually.

I thought I would be able to use the subtotal tool to separate the states and then within the states do the Type, but when I try that, Excel deletes the store totals.

SUrely there is a way to this without manually going through thousands of lines of detail. I know I could do it with SUMIFS at the bottom of the report, but how do I do this and make it automatic??

Thanks, Paul