Excel SUMIFS formula calculates the sum of values that meet any criteria. For example, you can sum up the total sales in east zone for product Pod Gun using SUMIFS formula.