Sumproduct Count multiple criteria with range over multiple rows and columns

Hey everyone,

Any help would be greatly appreciated...

Struglling to figure out a formula to count multiple criteria with range over multiple rows and columns... assuming I need a SUMPRODUCT but cant workit out.

I have attached an example workbook with further explanation, but I'll also have a go at describing below:

Values are within C8:K17
Dates in C7:K7
Asset ID in B8:B17

I need a forumla in N8 that looks at a start date in N7 and end date in O7 and asset ID in M8. With the below logic

Count how many values in C8:K17 if:
C8:K17 > 100
C7:K7 >= N7
C7:K7 < O7
B8:B17 = M8

Maybe:

=IFERROR(INDEX($C$8:$K$17,MATCH($M8,$B$8:$B$17,0),MATCH(N$7,$C$7:$K$7,0)),"")

Unfortunately that just returns the value from the INDEX MATCH MATCH criteria. I need something the counts the amount of values that meet all criteria.

Managed to figure it out...

=SUMPRODUCT(($B$8:$B$17=$M$8)*($C$7:$K$7>=N7)*(C7:K7<O7)*(C8:K17>100))