I don't know how to title this. However the question is similar but the output I need is different. Hopefully screen shot will show more clarity.

With formula showing:

[![with formula showing](https://i.stack.imgur.com/tOuxc.png)](https://i.stack.imgur.com/tOuxc.png)

What I'm trying to do and hopefully is able to do is, I need to do all those sum's and for the answers to be in the cells shown in total 1 and total 2. For those totals I did it manually, is there a way to do it automatically?

When I do subtotal for instance, I can do each block of sums, but I get the total answer for the whole table and not for each section as shown in the image. When I drag the sum down, I have to delete every other row. Is there a cleaner way?

Without formula showing:

[![without formula showing](https://i.stack.imgur.com/OffsZ.png)](https://i.stack.imgur.com/OffsZ.png)

Thank you for any help in advance.