### 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

Length:
11:53