SUMPRODUCT: The Most POWERFUL Excel Function

➡️ Download the Excel sheet here! Excel worksheet: https://www.yourcfoguy.com/templates/sumproduct-worksheet The SUMPRODUCT function is my favorite function in Excel, and replaces the need for XLOOKUP, INDEX / MATCH, SUMIFS, COUNTIFS, and AVERAGEIFS. In today’s video, I'll show you how you can not only use this function, but also understand what's happening behind the scenes. By the end of this tutorial, you'll be a SUMPRODUCT pro! ⏱️ TIMESTAMPS 0:00 Intro 0:12 Weighted Average 0:51 Lookups 3:01 How the SUMPRODUCT Function works 5:05 SUMIFS (and) 5:54 SUMIFS (or) 7:24 COUNTIFS & AVERAGEIFS ABOUT THIS CHANNEL Looking to level up your career in Finance & Accounting? You're in the right place. Each week I upload videos around Accounting, FP&A, and Excel to help you grow in your career and learn something new. ⚡️ Check out my channel here: http://www.youtube.com/@yourcfoguy Don’t forget to subscribe! 🔎 FIND ME AT https://www.yourcfoguy.com ➡️ Subscribe to my Newsletter! https://www.yourcfoguy.com/newsletter 🔗 FOLLOW ME ON SOCIAL Get updates or reach out to get updates on mySocial Media Profiles! LinkedIn: https://www.linkedin.com/in/joshaharonoff Twitter: https://www.twitter.com/yourcfoguy #Sum #SUMPRODUCT #Excel #Dashboards #Financials #accountingprofessionals #Tutorial #yourcfoguy