Dynamic SUMIFS on table with multiple columns of data?

[wish2bflying]

The lower table refers to the upper table. The upper table is somewhat successfully dynamic

(side note: if I could use:
=SUMIFS($G$4#,$M$4#,$O4#,$K$4#,Q$3#)
instead of:
=SUMIFS($G$4:$G$1000,$M$4:$M$1000,$O4#,$K$4:$K$1000,Q$3#)
that would be cool)

Is there any way to modify my formulas in the lower table to also make it dynamic? The periods in the source data will be added to over time. I need to sum each CritChar by Period from the source data (way, way too big to attach).

DraftInputs.xlsx
	O	P	Q	R	S
2				Periods
3	Code	CritChar	8	9	10
4	CALB	CRIT2	37.75	4	25.5
5	CMMI	CRIT1	25.75	8.75	7
6	PROG	CRIT1	35.5	20.25	10.5
7	CMMP	CRIT1	5	0.75	0
8	NCON	CRIT3	1.5	5.25	3.5
9	MANI	CRIT1	2.5	4	4.5
10	INSR	CRIT2	0	0.5	1.75
11	FAIR	CRIT1	1	0	0
12
13			8	9	10
14		CRIT1	69.75	33.75	22
15		CRIT2	37.75	4.5	27.25
16		CRIT3	1.5	5.25	3.5
17		CRIT4	0	0	0
18		CRIT5	0	0	0
DAVID

Cell Formulas
Range	Formula
Q3:S3	Q3	=TRANSPOSE(UNIQUE(FILTER(K:K,(K:K>=0)*(ISNUMBER(K:K)),0)))
O4:O11	O4	=UNIQUE(FILTER(M:M,(ISTEXT(M:M)*(M:M>0))),0,0)
P4:P11	P4	=XLOOKUP(O4#,VISJOBCODES!A:A,VISJOBCODES!C:C)
Q4:S11	Q4	=SUMIFS($G$4:$G$1000,$M$4:$M$1000,$O4#,$K$4:$K$1000,Q$3#)
Q13:S13	Q13	=Q3#
P14:P18	P14	=INSPCOSTS!C4
Q14:S18	Q14	=SUMPRODUCT(($P$4#=$P14#)*($Q$3#=Q$13)*($Q$4#))
Dynamic array formulas.