Excel Array Formula: Count Rows with OR Condition - Excel MMULT Function (Part 2/3)
Jan 23, 2017 #value
In this video I introduce Excel's Matrix Multiplication formula - the MMULT function. In simple steps I explain how you can use MMULT to solve complex problems.
Download the Workbook here: https://www.xelplus.com/excel-arrays-count-unique-items-with-mmult-function/
Visit Part 1 here:
Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)
https://rumble.com/v2skesm
And Part 3 here:
Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)
https://rumble.com/v2skgg4
In this example I use the MMULT formula to get the number of rows (workshops in this case) that contain at least one of the criteria (companies in this case). The analysis involves multiple criteria with an OR condition.
I first explain the basics and the rules you need to follow to use the MMULT formula correctly. If you don't, you formula result will be #value. I then use the SUMPRODUCT, together with MMULT to get unique count by rows. To make it more dynamic, I use the COLUMN function together with TRANSPOSE.
In the last video, I showed you how you can use helper cells first and then how to combine SUMPRODUCT with FREQUENCY function to get a one formula array solution.
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
-
LIVE
Right Side Broadcasting Network
8 days agoLIVE REPLAY: President Trump Keynotes Turning Point Rally in Duluth, GA - 10/23/24
5,549 watching -
1:42:18
Fresh and Fit
9 hours agoMiles & Locario Return!
102K17 -
1:00:21
Man in America
14 hours agoThe Dark Alliance of Big Pharma & Big Food w/ Dr. Tenpenny
59.4K40 -
1:20:34
Glenn Greenwald
11 hours agoSYSTEM UPDATE FLASHBACK: The West Embraces Online Censorship
113K77 -
6:11:58
The Charlie Kirk Show
13 hours agoTurning Point Action presents Georgia for Trump featuring Charlie Kirk, RFK Jr. & Donald Trump!
282K164 -
1:02:02
The StoneZONE with Roger Stone
8 hours agoThe RFK-Trump Fight to Make America Healthy Again! w/ John Richardson | The StoneZONE w/ Roger Stone
68K17 -
1:58:57
2 MIKES LIVE
12 hours ago2 MIKES LIVE #133 News Breakdown Wednesday!
77.5K11 -
56:13
Sarah Westall
11 hours agoIs our Magnetosphere being Destroyed? Why it Matters for all Life on the Planet
65.8K19 -
1:13:05
The Amber May Show
13 hours ago $6.54 earnedMake America Healthy Again | The Hateful Rhetoric & The Destruction of The Family | Kelly Schwartz
53.3K12 -
1:34:04
Redacted News
13 hours agoUkraine admitting DEFEAT in last ditch move? Putin and BRICS slam US Dollar | Redacted Live
152K356