Sum function formula or alternate

[Khatri1001]

Hi,
I am new to this forum and would like to receive help with a formula for particular set-up.
My spreadsheet consists for committee member time sheet that includes attendance Time-In and Time-out and a column that calculates Total Hours for each event.
There are 6 different meeting events that the committee member attends.

The sum formula I would like help with is that, in the Activity column (Col c) with "Council Meeting", to add up all the Total Hours (Col F) for all "activities" in Column H, from that "Council Meeting" and up to all the other meetings (non-"Council meetings"). This summation to be repeated for each occurance of "Council Meeting".
I have colored the band that needs to be added.
My formula works for the first set, but fail as it goes down the table.

Thanks for you help.
Razak

Per Diem Tracker v2.1-for Peneet.xlsm
	B	C	D	E	F	G	H	I
1	Time Sheet
2
3	Member Details:	Name		Email		Phone	Appointment Date
4		Superman					December 14, 2021
5
6	Daily Per Diem Hours	Total Hours Worked	Total Work Days				Appointment Term End Date
7	7.25	40.25	5.55				December 13, 2022
8
9
10	Date	Activity	Time In	Time Out	Total Hours	Compensation	Column1	Invoice #
11	November 1, 2021	MPFAC Meeting Prep	8:00 AM	3:00 PM	7.00	$144.83	FALSE
12	November 10, 2021	OHT Subcommittee	8:00 AM	3:15 PM	7.25	$150.00	FALSE
13	December 2, 2021	Council Meeting	1:00 PM	3:00 PM	2.00	$41.38	16.25	ü works
14	December 14, 2021	Other Ministry engagement	1:00 PM	4:00 PM	3.00	$62.07	FALSE
15	December 16, 2022	Council Meeting	9:00 AM	6:00 PM	9.00	$150.00	16.25	(my formula fails)
16	December 17, 2021	Other Ministry engagement	1:00 PM	4:00 PM	3.00	$62.07	FALSE
17	December 20, 2021	Council Meeting	9:00 AM	6:00 PM	9.00	$150.00	16.25	(my formula fails)
18		Digital Subcommittee			0.00	$0.00	FALSE
19		External Ministry Engagement			0.00	$0.00	FALSE
20		MPFAC Meeting Prep			0.00	$0.00	FALSE
21		Council Meeting			0.00	$0.00	16.25
22					0.00	$0.00	FALSE
23					0.00	$0.00	FALSE
T1

Cell Formulas
Range	Formula
C7	C7	=SUBTOTAL(109,TimeSheet1[Total Hours])
D7	D7	=TimeSheet1[[#Totals],[Total Hours]]/WorkweekHours
H7	H7	=EDATE(H4,12)-1
F11:F23	F11	=IFERROR(IF(COUNT(TimeSheet1[@[Time In]:[Time Out]])=4,(IF([@[Time Out]]<[@[Time In]],1,0)+[@[Time Out]])-#REF!+#REF!-[@[Time In]],IF(AND(LEN([@[Time In]])<>0,LEN([@[Time Out]])<>0),(IF([@[Time Out]]<[@[Time In]],1,0)+[@[Time Out]])-[@[Time In]],0))*24,0)
G11:G23	G11	=IF([@[Total Hours]]<WorkweekHours,[@[Total Hours]]*20.69,150)
H11:H23	H11	=IF([@Activity]="Council Meeting", SUM(TimeSheet1[[#Headers],[Total Hours]]:INDEX($F$11:$F67,MATCH([@Activity],$C$11:$C$69,0))))

Named Ranges
Name	Refers To	Cells
'T1'!WorkweekHours	='T1'!$B$7	D7, G11:G23

Cells with Data Validation
Cell	Allow	Criteria
B11:B70	Any value
C11:C69	List	=Sheet1!$B$2:$B$8
D11:H70	Any value
I11:I14	Any value
I15:J71	Any value

 

[Fluff]

How about

=IF([@Activity]="Council Meeting", SUM(F$10:F11)-SUM(H$10:H10),"")

 

[Khatri1001]

How about

=IF([@Activity]="Council Meeting", SUM(F$10:F11)-SUM(H$10:H10),"")

Thank you Fluff. Tried it and this works very well.
Appreciate your assistance.

 

[Fluff]

You're welcome & thanks for the feedback.