Why Pro Excel Users Love SUMPRODUCT!

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

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

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

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


🎁 SHARE this video and spread the Excel love.

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

⏲ 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

[pipo]

You are a great person. Straight to the point, no blablabla.... Really appreciate your tutorials.

[gospelmoto]

Learned something new today. I've heard sumproduct before but I am not using it. Now, I'm inspired to use it. Thanks for your video once again. You're getting lovelier and lovelier each time I watch you.

[jonk]

This is priceless! I am amazed by how simple you make it look. You're truly an excel legend. I will definitely watch it over and over again especially to understand how the sign works. Many thanks Mynda

[sachinrv]

SUMPRODUCT is amazing, as it can take care of AND, OR and combination of AND OR conditions. Thanks for the useful video. The most important feature of this function is that it can take care of ARRAY operations, so those who don't have Office 365, this function is super useful.

[roywilson]

Sumproduct has so many uses, I still find myself reaching for it in preference to the newer functions. It is extremely useful and should, I think, be part of all Excel courses from the intermediate level up.
Thanks for bringing it to the attention of some newer users who may not have heard of it's extended uses.

[hk_k]

I was dealing with countifs 10+criteria within different spreadsheet and the my colleague's code was longer than a page and unreadable. GPT revised it for me to sumproduct, clean and tidy, but this video tells me the logic behind clearly! Thanks.

[aiasaiascon]

This is a FANTASTIC video Mynda !!!! You are Thee Excel Darling!!!

[spilledgraphics]

Long Live SUMPRODUCT. Thank you Mynda!

[chrism]

Thanks Mynda! I use it often for weighted averages

[TakeonmeLiive]

Using the SIGN function trick was a real gem. Thanks!

[danteencinas]

Thank you for this wonderful explanation of the SUMPRODUCT function!

[iankr]

Many thanks, Mynda. Great techniques. The SIGN function is a new one with me!

[Quidisi]

SIGN() is my new favorite function. Amazing. I always struggled with how to reduce my array result to either 0 or 1.

Since Excel now handles arrays natively - I still don't see any reason to use SUMPRODUCT vs just summing your array calculations. For example, this
=SUMPRODUCT((C6:C9>85)*(D6:D9>15), C6:C9, D6:D9
is equal to this


If anyone knows an example where SUMPRODUCT must be used, please share!

Mynda - loving SIGN(). I also tried it, and you can use it in lieu of double minus signs.
I think I will just start using SIGN to be consistent. Thanks so much!

[mac]

Nice video production Mynda, loved the content too as always :)

[jdp]

I also use Sumproduct as an alternative to xlookup or vlookup as the latter returns ref errors if the relevant files are not open

[hayekfriedman]

Another excellent video. What I have never been able to make work is using sumproduct with iferror to exclude text values within an array. I only ever end up with SPILL!!

[michaelkuhn]

Excellent video. Thanks for such great examples and explanations.

[ExcelWithChris]

Another GREAT one. Thanks from South Africa.

[AcukOndanAcukBundan]

Your Mynda videos are really nice, but I can't say that the thumbnails of your videos are very good. I have been watching you for a long time and I like your videos. I think you can find a designer.

[ousmanesidibe]

liked it before even watch the video, cause i am confident it just gonna be another great content 👍