AVERAGEIF Formula on an array of data

Hello Shoto, try this.

Consider the data is in A2:E10. A15:A17 is names, like Peer, Manager & Report.

In B15, then copy down

=ROUND(SUMPRODUCT((A$2:A$10=A15)*COLUMN(B$2:E$2)^0,B$2:E$10)/SUMPRODUCT((A$2:A$10=A15)*ISNUMBER(B$2:E$10)),1)

COLUMN(B$2:E$2)^0 used here to equalize the SUMPRODUCT dimension to avoid any multiplication by text. So adjust this accordingly.