AVERAGEIF ACROSS MULTIPLE COLUMNS..EXCLUDING DATES

[JuicyMusic]

Hi, I have seen several awesome solutions using SUMIF and SUMPRODUCT for but excluding certain criteria. All of them were for vertical data set (descending rows). I need the same solution across multiple columns (horizontal).

I am only allowed to send a snapshot. I can't wait to see how simple and awesome the solution really is. The column circled in Red is where the AVERAGE formula is.

Thanks everyone!
Juicy,

 

[Fluff]

How about something like

=averageifs(B2:I2,B1:I1="Score")

 

[JuicyMusic]

Hi Fluff, I get a message: You've entered too few arguments for this function so I removed the "s" after averageifs. Let me know. Thansk!

 

[Fluff]

Oops, it should be

=averageifs(B2:I2,B1:I1,"Score")

 

[JuicyMusic]

Hahaaa......I saw the equal sign but thought this is how you write an IF formula for Average (instead of a comma) . I'm glad you did Oopps because I will remember this formula.
You are awesome! I anchored it. THANK YOU!!!! SOLVED

=AVERAGEIFS(B3:I3,$B$2:$I$2,"Score")

 

[Fluff]

You're welcome & thanks for the feedback.