Excel Forum



Excel Magic Trick #122: Sum With More Than 1 Criteria


See how to Sum With More Than 1 Criteria with four different formulas and functions: SUM, SUMPRODUCT, SUM & IF, COUNTIFS. See how to do it in a table without using a PivotTable.

SUM items based on Two Conditions. SUM items based on two criteria. SUM items based on multiple conditions criteria.





Got a Question? Ask it Here in the Forum.