AverageIF in an Array

Hi All

I have a need to take a standard report of responses in a standard format, and summerise the averages per responder category (Self, Supervisor, Customer etc) using a formula with Averages.

I have mocked up the report, and hopeful output.

The column headings in the report are not always in the same order, but the content is consistent.

Wonder if someone can help me complete the AverageIFs, which are split by responder, and in the right category column.

Jay

Try

in B21

=IFERROR(AVERAGEIF($A$3:$A$20,B$19,OFFSET($A$3,,MATCH($A21,$B$2:$F$2,0),COUNTIF($A$3:$A$20,"*?"))),"")

Copy across and down

Perfect - Thank You