SUMPRODUCT: The Most POWERFUL Excel Function

Published: 07 June 2024
on channel: Josh Aharonoff (Your CFO Guy)

15,328

479

➡️ Download the Excel sheet here!
Excel worksheet: https://www.yourcfoguy.com/templates/...

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:    / @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:   / joshaharonoff
Twitter:   / yourcfoguy

#Sum #SUMPRODUCT #Excel #Dashboards #Financials #accountingprofessionals #Tutorial #yourcfoguy

On this page of the site you can watch the video online SUMPRODUCT: The Most POWERFUL Excel Function with a duration of hours minute second in good quality, which was uploaded by the user Josh Aharonoff (Your CFO Guy) 07 June 2024, share the link with friends and acquaintances, this video has already been watched 15,328 times on youtube and it was liked by 479 viewers. Enjoy your viewing!