Is there a way to generate a dynamic table of subtotals?

[JenniferMurphy]

Is there a way to generate a dynamic table of subtotals from the data in another table?

The table on the left contains donations made to several people during 2021. The table on the right shows the subtotals for each of these people. Is there a way to generate the table on the right dynamically -- that is, without me having to enter each name on its own row -- so that if I add a new donation to a new person in the table on the left, the table on the right will automatically grow a new row? Thanks

Donations & RMD.xlsx
	B	C	D	E	F	G
5	Date	To	Amount		Name	Year Total
6	2/03/21	Susie	$100		Freddie	$800
7	2/14/21	Freddie	$200		Johnny	$100
8	3/13/21	Freddie	$200		Molly	$700
9	4/01/21	Susie	$100		Susie	$400
10	5/22/21	Molly	$300		Total	$2,000
11	6/15/21	Molly	$200
12	6/19/21	Johnny	$100
13	7/07/21	Molly	$100
14	8/31/21	Freddie	$300
15	9/09/21	Susie	$200
16	9/21/21	Freddie	$100
17	12/22/21	Molly	$100
18	Total		$2,000
Test2

Cell Formulas
Range	Formula
G6:G9	G6	=SUMIFS(Table1[Amount],Table1[To],"=" & [@Name])
G10	G10	=SUBTOTAL(109,[Year Total])
D18	D18	=SUBTOTAL(109,[Amount])

 

[Dave Patton]

The posts above except mine use =SUBTOTAL(109,[Amount]).

My Excel which is the latest 14931.20120 will not accept that syntax.
The function =SUBTOTAL(109,Table1[Amount]) does work.

The recent version of 365 takes a long time to load the first file and I often get the message "File Not Responding". I followed instructions to correct the problem but it just removed the program.

My apologies if I am not allowed to ask questions. If I started a new thread, I would refer to this thread.

 

[Peter_SSs]

How is it entered?

You do not enter it, Excel does.
Create the table with the other values.
Select something in the table
Table Design ribbon tab -> Total Row

 

[Dave Patton]

Thanks Peter_SSs. Your post #12 worked.