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 ...
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...
Simple Excel Function to Combine Text with a Separator
Tutorial: Excel function that makes combining text very easy. This function is simpler and better th...

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.