Average IFS with Multiple Criteria AND Multiple Dynamic Columns

Hi all,

I am having a problem solving this so I hope you can help and attached the sheet with the result FYI.

I would like an average of a number that is in multiple columns and using multiple criteria, the attached spreadsheet explains better.

Thank you in advance

Mark

perhaps in t5
=SUMPRODUCT(($C$5:$Q$15)*($C$4:$Q$4=$T$4)*($B$5:$B$15=S6))/SUMPRODUCT(($C$5:$Q$15>0)*($C$4:$Q$4=$T$4)*($B$5:$B$15=S5))

Hi Davsth,

Thank you for relying quickly but that returns a value of '145' and the answer should be 12 in T5, any other suggestions?

Thank you
Mark

Thanks both (Davsth, figured yours out in the end with a slight adjustment) all three worked very well in the end. Thank you