️DOWNLOAD the example file here: https://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs
RELATED LESSON – Database Functions: https://www.myonlinetraininghub.com/easy-excel-database-functions
LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/
EXCEL NEWSLETTER – join 450K subscribers here: https://www.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: https://www.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: https://www.myonlinetraininghub.com/excel-forum
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
Take the opportunity to connect and share this video with your friends and family if you find it useful.