Countif sumif

I want some help in countif and sumif .

I have hundreds of question (10 shown for sample on right side of attached sheet)


I want to get count, sum and average for each condition.

Please help me in the formula so that I can drag the formula down

Currently, I have written formula for only 1 question which is not draggable

Try these:

B6 =COUNTIFS(K:K,C$2,L:L,C$3)

C6 =SUMPRODUCT((K$4:K$11=C$2)*(L$4:L$11=C$3)*(M$3:V$3=A6)*(M$4:V$11))

D6 =C6/B6

if you are able to use PowerQuery try this