Excel SUMIFS Formula Generator

Add values that meet multiple criteria

The range of cells to sum if criteria are met. Example: B2:B10
First Criteria (Required)
The first range to evaluate against criteria 1
The condition to check (number, text, or cell reference)

Generated Formula:

A few examples of using SUMIFS function

Scenario Formula Remarks
Sum sales where the category is "Tech" =SUMIFS(C2:C10, B2:B10, "Tech")
Two Conditions =SUMIFS(C2:C10, B2:B10, "Tech", D2:D10, "North")
Using Cell References =SUMIFS(C2:C10, B2:B10, E2, D2:D10, E3)
With '*'' Wildcard =SUMIFS(C2:C10, A2:A10, "L*") Partial Match
Date Condition Example =SUMIFS(C2:C10, E2:E10, ">01-01-2022")
Blank and Non-Blank Conditions =SUMIFS(C2:C10, D2:D10, "<>") <> means "not empty"