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/