SUMIF & COUNTIF — Excel Conditional Formulas Made Simple

If you work with sales data, budgets, or inventory, SUMIF and COUNTIF are the formulas you'll use every single day. They answer questions like "How much did we sell in the East region?" or "How many orders are over $500?" — in one formula, no manual filtering required.

SUMIF — Sum Values That Meet a Condition

=SUMIF(range, criteria, [sum_range])

Example: =SUMIF(B2:B100, "East", D2:D100) → Sum all sales in column D where column B says "East"
Greater than: =SUMIF(C2:C100, ">500") → Sum everything over $500 in column C
Text wildcard: =SUMIF(A2:A100, "New*", B2:B100) → Sum values where product starts with "New"

SUMIFS — Multiple Conditions

=SUMIFS(sum_range, range1, criteria1, range2, criteria2)

=SUMIFS(D:D, B:B, "East", C:C, ">1000") → Sum column D where region="East" AND sales>1000. Supports up to 127 condition pairs.

COUNTIF / COUNTIFS — Count With Conditions

=COUNTIF(C:C, ">100") → Count how many cells in C are over 100
=COUNTIFS(B:B, "Complete", C:C, ">="&TODAY()) → Count completed tasks due today or later

AVERAGEIF — Average With Conditions

=AVERAGEIF(B:B, "East", C:C) → Average of column C where column B is "East"

Generate Your Formula in English →