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 - @csvkarl"/> 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 - @csvkarl - Tikwm"/> 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 - @csvkarl"/>
  1. Home
  2. Detail

@csvkarl: 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

Excel Tutorials
Excel Tutorials
Open In TikTok:
Region: US
Wednesday 25 March 2026 14:55:00 GMT
1622
126
0
1

Music

Download

No Watermark .mp4 (3.73MB) No Watermark(HD) .mp4 (3.73MB) Watermark .mp4 (3.26MB) Music .mp3

Comments

There are no more comments for this video.
To see more videos from user @csvkarl, please go to the Tikwm homepage.

Other Videos


واحد مجهود، واتنين صبر، وتلاتة رضا، يوصلوك لأبعد مكان.
واحد مجهود، واتنين صبر، وتلاتة رضا، يوصلوك لأبعد مكان. "واحد رزق يكفّي، واتنين صحاب يخلّوا الدنيا تضحك، وتلاتة مواقف حلوة تفضل فاكرها على طول.
It’s a boy 💙#viral #bebe #revelaciondegenero #paratiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii #parati
It’s a boy 💙#viral #bebe #revelaciondegenero #paratiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii #parati


#elvisnaciligjerata#kuranishqip#elvisnaciofficial#islami#dijenirrethislamit
#elvisnaciligjerata#kuranishqip#elvisnaciofficial#islami#dijenirrethislamit

About

Legal