Excel Tutorial Interview Series: Part II. Today, we will work with an interview example about how to calculate average with three criteria from another sheet. 📚Excel Formula Clean Names → =TRIM(PROPER([@Entity])) Formula → =IFERROR( AVERAGEIFS(Table3[Views],Table3[Helper Medium],"Youtube", Table3[Helper Entity],[ @Influencers],Table3[Views],">0"), "NOT FOUND") ✨Breakdown AVERAGEIFS(Table3[Views], → Range to average Table3[Helper Medium],"Youtube",→ Only include rows where the medium is “Youtube” Table3[Helper Entity],[ @Influencers] → Only include influencers that match the current range ,Table3[Views],">0"),→ Filter by views and ignore any rows where Views is zero or less "NOT FOUND")→ If the formula can’t return a result, show this message 💬 Let me know in the comments section if it worked for you 📲 Share with a friend who also wants to improve their Excel skills 💚 Level up your Excel game and your career. Hit the plus for weekly tutorials #excelfunctions #interviewquestions #exceltutorial