That is my goal: make the complicated, less complicated. I agree with you Dennis D, for me too, I must always do both the New and Old School each time I make a formula because it make the transition to the new world easier!! It also has the added memory benefit that if you do the new and then do the old, the part in your brain that already encoded memory for the old, now gets encoding for the new : )

es, MMULT is amazing. Be sure to check out the reference video : )

You are welcome for the fun, Teammate : )

Glad it is amazing for you, romeo!!!!

Yes, Double Or Logical Tests ARE Amazing!!! Thanks for stopping by, Chris : ) : ) : )

Yes!!!! Speechless is fun : )

Oz Telling Tales, Rad!!!!! Power Query can make a Bridge Table for a Data Model Pivot Table too: kzfaq.info/get/bejne/rcmnicKDsLW3ZYk.html

Glad you like it!!!

Thanks for your kind words! It is fun for me to make and if it brings light to you and others, that is even better!! Thanks for stopping by in the comments, ripudaman!!!!

You are welcome!!

You are welocme, K D - thanks for the starts and thumbs ups : ) : )

Glad it is great, Anthony!!

Yes it is. Do check out the MMULT video, I explain all the beautiful complexities : )

Glad it is EXCELlnet for you, Ashok!!!!

You are welcome, Abdul!!!

AMEN !!! AMEN !!!!!

Always glad to bring new things to our Team, Amardeep!!!!

@@spilledgraphics Thanks, Teammate!!!

Why not? Right, Teammate of Camtasia, Oz!!!!!!!

@@excelisfun It's BEATUIFUL and fun!

You are welcome, ashish!!! Thanks for your magic and rocking comments : ) I have a few epic videos about charts. Here are two: kzfaq.info/get/bejne/i7yKlsSesLKul4k.html kzfaq.info/get/bejne/rrKdp6qcnL_RqWw.html

Boom, Boom, Boom!!!!

Well, the Old School is easy too : )

You are welcome : )

You are welcome, Hussein!!!

I will : )

Glad it is fantastic for you, Sachin : )

Glad to help, Henrik!!!!

@@excelisfun glad that u share All this good knowlege to US ALL 😉💪

Glad it is amazing for you, Michael!!!!

Try this great Excel question site: mrexcel.com/forum

Thanks, Phone Excel : ) : )

Déjà Vu. You are right. I already did this exact example BEFORE Spilled Array Formulas: MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships, kzfaq.info/get/bejne/epOcm9KJsJy7eZs.html MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship, kzfaq.info/get/bejne/rcmnicKDsLW3ZYk.html But last week while I was teaching this topic in my class, I relaized that with the new Excel Engine, there is a different way : ) So I had to make a video : ) : ) : ) : )

You are at my ankles. But I am at your ankles. The beauty of being human is that we are each, uniquely, unparalleled and with gifts to give to the world that no one else can give : ) But, I have been making videos for 15 years and you have been making videos for a few months, so probably I have some accumulated lessons that lead to efficiency. So much to learn, we both! It never stops, as along as we are doing something that we love : )

Always. Before SUMIFS and other new functions, it was mostly mandatory.

Fun with Excel ; )

@@excelisfun i think we d'ont get just fun with excel , but more becuase the work becomes fun with excel 🤣

I do have a Art Degree from SAIC (School of the Art Institute of Chicago). When I produce, edit and make, I do think of it as art : ) Thanks for noticing the art in it, Sam Sami!!!!

I already have a video about This Many - To - Many Relationship in Power BI: Power Query and Data Model solution here: kzfaq.info/get/bejne/rcmnicKDsLW3ZYk.html

@@excelisfun Lucky me...you even used the exact same data set :D. Great videos. Thanks

Thanks for the Lavender Heart, Lamees!!

Try this great Excel question site: mrexcel.com/forum

Try this great Excel question site: mrexcel.com/forum

The second formula works in any version. Did you watch the whole video?

Nope. Microsoft only made the New Excel Calculation Engine and Dynamic Arrays available in Office 365. Office 2019 is the first Disc Install Version that was dead on arrival. The day that 2019 was released, Office 365 already had the Beta Dynamic Arrays. There are so many things like Dynamic Arrays, LET Function, Power Pivot by default, Power Query automatic update and many other features that are so much better than any other version, that is makes it the ONLY version to have. The problem still exists that many entities, including the one I work for, have not switched to Office 365 and have technical barriers before they can switch. But in a year or two, all entities will have to strive to switch to Office 365, because it is just that good, and has that many efficiencies that make the switch worth it. The benefits of Office 365 out weigh virtually all the costs.

I am not sure what the issue is : (

The issue is that it should return value not nothing

I already made a video about the Power Query and Data Model solution here: kzfaq.info/get/bejne/rcmnicKDsLW3ZYk.html

Yes, I though I showed that formula in the video?

@@excelisfun Indeed , with OR (+) , no need of OR (+). Instead of if((col1=e5)+(col2=e5)+...n columns , witch creates a 1 column array for the sumifs criteria argument we can use if(e5=array), that delivers an array of 6x3 that can be used as criteria in sumifs and then sum(sumifs) delivers the result.

@@Excelambda Wow, Wow!!!!! That is beautiful : ) I totally missed that you put the full array in logical_test and value_if_true !?!?!? Beautiful solution. I have added it to the downloadable file. I miss stuff that people write in the comments often, but today I have an unfortunate reason: I crashed on my bike yesterday and was at hospital until midnight yesterday, so today I am a bit foggy... Thanks for making the Team better with your cool contributions : )

Does that help?