Excel - how to calculate sum of multiple rows into different columns

Question

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:

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:

Thank you for any help in advance.

Answer 1

The AutoSum button or formula can be found in the Function Library group on the Formulas tab. Take a look at this screenshot:

The AutoSum button or formula can also be found in the Editing group on the Home tab.

In Excel, the AutoSum function has a hotkey/shortcut.
In Excel, the hotkey or shortcut for the AutoSum function is Alt + =.

Select a list of data in Excel, then press the Alt + = keys at the same time to add the sum value to the bottom of the list.

Multiple column autosummation

1. As indicated in the left screen photo, select multiple columns to AutoSum.

2. Press the Alt + = keys at the same time to use the AutoSum function.

Note: The AutoSum function can also be used by going to Formula > AutoSum or Home > AutoSum.