The Excel SUMPRODUCT function is one of Excel's most versatile and underutilized functions allowing for flexible aggregations of data.

⬇️DOWNLOAD the example file here: https://www.myonlinetraininghub.com/e...

🎓RELATED LESSON - Database Functions: https://www.myonlinetraininghub.com/e...

LEARN MORE
===========

🏫 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e...

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 FOLLOW me on LinkedIn:   / myndatreacy  

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...


⏲ TIMESTAMPS
==============
0:00 SUMPRODUCT Function
0:24 Easy SUMPRODUCT Formula
1:03 SUMPRODUCT with AND Criteria
2:58 SUMPRODUCT with OR Criteria
4:43 SUMPRODUCT with Single Criteria
5:49 SUMPRODUCT to count
6:49 SUMPRODUCT Rules