SUMPRODUCT Function

SUMPRODUCT Function

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.

Please share

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!

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Abdelrahman Abdou
Latest posts by Abdelrahman Abdou (see all)
It's only fair to share...Share on Facebook
Facebook
0Pin on Pinterest
Pinterest
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin