Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3)
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: https://youtu.be/vC9S0oCa_Xk
Part 3 Video: https://youtu.be/qd8vyLcpogw
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/
Видео Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3) канала Leila Gharani
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: https://youtu.be/vC9S0oCa_Xk
Part 3 Video: https://youtu.be/qd8vyLcpogw
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/
Видео Excel Array Formula: Count Rows with OR condition - SUMPRODUCT & FREQUENCY Functions (Part 1/3) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel DGET Function Solves 2 of Your VLOOKUP ProblemsMaster Excel's SUMPRODUCT FormulaComprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)This Excel Chart will grab your attention (Infographic template included)Excel Array Formula: Count Rows with OR Condition - Excel MMULT Function (Part 2/3)Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5)10 Excel Things You Should NEVER Do and What to do InsteadSearchable Drop Down List in Excel (Very Easy with FILTER Function)3 EASY Ways to Find and Remove Duplicates in ExcelExcel for Accounting - 10 Excel Functions You NEED to KNOW!How to use Excel Index Match (the right way)Excel Dynamic Arrays (How they will change EVERYTHING!)Excel MOD Function - Easy Explanation & Practical Examples of MOD for WorkExcel 2016 AdvancedExcel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCTExcel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)How to Use Excel Checkboxes | Interactive Checklists & ReportsExcel SUMIFS: Sum Alternate Columns based on Criteria and HeaderExcel: Extract unique items for dynamic data validation drop down list