You can download the workbook here to follow along with the Video!
In this Video tutorial, we explain the SUMPRODUCT function, and how to use it to sum the product of two or more arrays.
I also show you in Office 365, the SUM function can now handle array operations, because of the new dynamic arrays in Excel!
We also show how you can use the SUMPRODUCT function to sum and count with Criteria just like SUMIF, SUMIFS, COUNTIF and COUNTIFS functions.
We also show how to use it to SUM and COUNT with OR and AND conditions, which is something that the SUMIF, SUMIFS, COUNTIF, COUNTIFs functions can’t do!
Please watch the video and let me know if you have any comments or feedback in the comments section below.
Special Thanks to Leila Gharani for giving me the inspiration to do this Video!
I hope you like that Tutorial.
If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!
Ace your Excel Career by learning how to create Excel Dashboards!
Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:
1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others
2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.
3-Learning Dashboarding techniques.
4- Building a Complete Excel Dashboard.
Click here Find out more
This is one of the most helpful and comprehensive dashboard classes I have taken. I was able to take what I learned in the evening and apply it at work the next day. I created a compensation dashboard and my boss was amazed! Thank you Abdelrahman Abdou for an awesome class.