Excel Forum

Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula

See how to Use Boolean Math and the SUMPRODUCT function to add with 4 criteria, including an option for All items in column. Also see an amazing use of the IF function inside the SUMPRODUCT function to deliver either a single cell or a range to match the All criteria. barry houdini and jasonb75 at Mr Excel Message Board give us some amazing formulas.

Got a Question? Ask it Here in the Forum.