Excel Forum

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.