Use of Averageif on Multiple Columns

I really can't find the solution online so i'm posting my own thread.

I need to get the average of all the data (based on the same criteria) found on different columns.

Here's the excel table attached

Try this array formula entered with CTRL + SHIFT + ENTER

=AVERAGE(IF($E$2:$E$21=B25,$F$2:$AM$21))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Thanks! I know now how to do array but when I did that to my file it's giving me an incorrect answer.

Here's the formula I had with the burly braces on both ends =AVERAGE(IF($E$2:$E$21=B25,$F$2:$AM$21)) but I get an answer of 1.35 instead of 5.625

I tried doing it on the NETMAN1. I re-did everything but same result.

OK, It's counting blanks as 0 throwing off the average..

Try
=AVERAGE(IF(($E$2:$E$21=B25)*($F$2:$AM$21<>""),$F$2:$AM$21))

You are a GURU! Thanks!

You're welcome.