Question on Complex Sum and Count

[p9j123]

Based on this table, I need help on creating a formula in K3 to count and in K4 to sum based on the following condition

In K3 --> countif B1:G1 = K3, A3:A5 = K1, B3:G5 is number

Book4
	A	B	C	D	E	F	G
1		Jan	Jan	Jan	Feb	Feb	Feb
2		01-Jan	02-Jan	03-Jan	01-Feb	02-Feb	03-Feb
3	James	RD	100	200	RD	200	200
4	Aubrey	300	RD	300	RD	VL	300
5	Alex	100	100	120	200	200	VL
Sheet1

So in the example below, K3 is 2 and K5 is 600 because it meets all the above criteria.

Book4
	J	K
1	Employee Name	Aubrey
2	Month	Jan
3	Count	2
4	Sum	600
Sheet1

 

[bebo021999]

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		Jan	Jan	Jan	Feb	Feb	Feb			Employee Name	Aubrey
2		01 January 2023	02 January 2023	03 January 2023	01 February 2023	02 February 2023	03 February 2023			Month	Jan
3	James	1	100	200	1	200	200			Count	2
4	Aubrey	300	RD	300	1	1	300			Sum	600
5	Alex	100	100	120	200	200	1
Sheet2

Cell Formulas
Range	Formula
K3	K3	=SUMPRODUCT(($A$3:$A$5=K1)*($B$1:$G$1=K2)*ISNUMBER(B3:G5))
K4	K4	=SUMPRODUCT(($A$3:$A$5=K1)*($B$1:$G$1=K2),B3:G5)

 

[p9j123]

Thank you so much, this works.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		Jan	Jan	Jan	Feb	Feb	Feb			Employee Name	Aubrey
2		01 January 2023	02 January 2023	03 January 2023	01 February 2023	02 February 2023	03 February 2023			Month	Jan
3	James	1	100	200	1	200	200			Count	2
4	Aubrey	300	RD	300	1	1	300			Sum	600
5	Alex	100	100	120	200	200	1
Sheet2

Cell Formulas
Range	Formula
K3	K3	=SUMPRODUCT(($A$3:$A$5=K1)*($B$1:$G$1=K2)*ISNUMBER(B3:G5))
K4	K4	=SUMPRODUCT(($A$3:$A$5=K1)*($B$1:$G$1=K2),B3:G5)