|
Featured Tutorial
Featured Macro
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
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