Excel Forum
Similar Content
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
How to Find and Fix Errors in Complex Formulas in Excel
Tutorial: Here, I'll show you a quick, simple, and effective way to fix formulas and functions in E...



Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Math


See how to extract records from a data set with 4 AND criteria and 3 OR criteria:
1.Boolean Logic Math
2.For AND criteria use Multiplication because 1*1 = 1
3.For OR criteria use Adding because 1+0 = 1
4.See the Functions: SUMPRODUCT, INDEX, IF, ROWS, SMALL, and ROW.
5.SUMPRODUCT formula for counting with 4 AND criteria and 3 OR criteria





Got a Question? Ask it Here in the Forum.