Uploaded October 2023 | Updated November 2026, 11 hours ago
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: myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs
🎓RELATED LESSON - Database Functions: myonlinetraininghub.com/easy-excel-database-functions
LEARN MORE
===========
🏫 LEARN MORE in my Excel courses: myonlinetraininghub.com
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 FOLLOW me on LinkedIn: linkedin.com/in/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: myonlinetraininghub.com/excel-forum
⏲ 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
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: myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs
🎓RELATED LESSON - Database Functions: myonlinetraininghub.com/easy-excel-database-functions
LEARN MORE
===========
🏫 LEARN MORE in my Excel courses: myonlinetraininghub.com
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 FOLLOW me on LinkedIn: linkedin.com/in/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: myonlinetraininghub.com/excel-forum
⏲ 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










