Premium Only Content
![Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)](https://1a-1791.com/video/s8/1/M/V/w/e/MVwek.qR4e.1-small-Excel-Array-Formula-Count-R.jpg)
Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)
Jan 18, 2017
Excel Array functions can be difficult to get the hang of. This video explains the logic behind arrays in simple steps while attempting to solve a problem (counting rows based on OR condition).
It also shows you a simple method you can use when you need to come up with other complex formulas.
Download the workbook here: http://bit.ly/2k3Bo80
Part 2 Video:
Excel Array Formula: Count Rows with OR Condition - Excel MMULT Function (Part 2/3)
https://rumble.com/v2skevq
Part 3 Video:
Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)
https://rumble.com/v2skgg4
This video is part 1 of a 3 video series. In each of the videos of the series I use a different Excel array formula to get to the same result.
In this video I show you how you can come up with an array formula that counts the rows if at least one of the lookup fields from the criteria list is in that row. It's an OR logical test involving multiple criteria. It shows a great use of the FREQUENCY function, the SUMPRODUCT formula and the ROW function.
In addition to solving this problem, I take you through the steps you can take to break down complex array formulas and show you tricks you can use to "follow" your formulas' results which helps you come up with other functions that can help you get to your answer.
Series 2 of 3, will introduce you to Excel's MMULT function (Matrix Multipication).
★ 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/
-
25:11
BlackDiamondGunsandGear
3 hours agoAnderson AR-15 / Is Budget Building Trash?
13.9K8 -
1:21:05
Michael Franzese
8 hours agoDemocrats MELTDOWN Over DOGE—Plus More on JFK’s Assassination | LIVE
79.4K96 -
10:02
RTT: Guns & Gear
17 hours ago $1.59 earnedEAA Girsan Influencer X 1911 - The Cheat Code For Accuracy
18.7K -
11:03
Degenerate Jay
3 days ago $1.33 earnedHenry Cavill James Bond Was Almost A Reality
26.5K8 -
31:58
CarlCrusher
1 day agoDiscovering the Secret Ultra Low Spectrum for UFO Contact and Skinwalker Ranch
17.9K -
3:44
Rethinking the Dollar
1 day agoMichigan’s Big Bitcoin Move—What It Means!
36.5K1 -
16:56
Chris From The 740
17 hours ago $0.75 earnedIs The Ruger RXM A Viable Carry Option? Let's Find Out!
23.1K4 -
38:28
Athlete & Artist Show
9 hours ago $6.46 earnedNHL 4 Nations Face Off High Stakes Betting
96.1K5 -
1:55:41
I_Came_With_Fire_Podcast
15 hours agoAncient Egypt's Rise: Lost Tech, Cult of the Blue Lotus, & Secrets of a Fallen Empire
80.4K18 -
49:24
Tactical Advisor
9 hours agoNew Holster & Home Defense Shotgun | Vault Room Live Stream 016
60.7K3