Excel SUMIF and COUNTIF: When and How to Use Each
2026-03-18
SUMIF (Single Condition Sum)
Sum all values where a condition is met. Sum amounts in C where status in A is "Paid":
=SUMIF(A:A, "Paid", C:C)SUMIFS (Multiple Conditions)
Sum amounts where region is "East" AND quarter is "Q1":
=SUMIFS(D:D, A:A, "East", B:B, "Q1")COUNTIF (Single Condition Count)
Count how many cells contain "Yes":
=COUNTIF(A:A, "Yes")COUNTIFS (Multiple Conditions)
Count active employees in the Engineering department:
=COUNTIFS(A:A, "Engineering", B:B, "Active")Using Wildcards
Count cells that contain the word "error" anywhere in the text:
=COUNTIF(A:A, "*error*")Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free