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
The Charlie Kirk Show
1 hour agoBiden Drops Out! LIVE with Charlie Kirk! 7/21/24
64,513 watching -
LIVE
Tate Speech by Andrew Tate
57 minutes agoEMERGENCY MEETING EPISODE 61 - $DADDY DOESNT PULL OUT
29,560 watching -
LIVE
Benny Johnson
1 hour ago🚨BREAKING: Joe Biden DROPS OUT, Democrats in PANIC, | This Was a SET UP
15,865 watching -
LIVE
Joe Pags
1 hour agoBiden Out!
3,354 watching -
LIVE
DDayCobra
1 hour agoJoe Biden QUITS
1,922 watching -
LIVE
NEWSMAX
8 months agoNEWSMAX2 LIVE | Real News for Real People
5,637 watching -
LIVE
RealAmericasVoice
20 days agoREAL AMERICA'S VOICE 24/7
6,417 watching -
19:24
Cody and Kellie
6 hours agoSummiting the Third Tallest Peak in Oregon
12.6K11 -
4:23:07
LumpyPotatoX2
6 hours agoFortnite on Sunday - #RumbleTakeover
36K3 -
13:20
barstoolsports
1 day agoWe Broke The MLB Home Run Record In 6 Hours
47.3K3