Sum a cell on multiple sheets based on two or more criteria

[mad3]

CM 2024 STATS.xlsm
	A	B	C	D	E	F	G
5	Team			1	2	3	4
6	Mad			2	0	0	1
7	Bunk			0	1	2	0
8				x	x		x
9	gm	Player	GP	1	2	3	4
10	1	Cruz	1	CM	GK		CM
11	1	August	1	CD	LM	GK	CD
12	1	Malik	1	ST	ST	ST	ST
13	1	Alex	1				RM
14	1	Adrian	1	GK	CM	CM	GK
15	1	Michael
16	1	Joesph	1	LM		RD	RD
17	1	Conor	1		LD	LD
18	1	Oscar	1	RD	RD	LM	LM
19	1	Keller	1	RM	RM	RM
GM1

 

[mad3]

I want to sum cell D7 (from all sheets) on totals sheet based on multiple criteria that checks to see if player in cell B10 and player in cell B16 are both playing a position other than 'GK'. If both players are playing a field position, cell D7 should be summed. I have about 20 sheets. Currently, I have a final sheet that shows totals for all sheets. Though, none based on a criteria.