Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Lesson 2

Counting in Excel: COUNT, COUNTIF and COUNTIFS

Count numbers, filled-in cells and cells that meet one or more conditions. The last one you write yourself.

  1. Count numbers: COUNT. COUNT only counts cells with numbers. Text like n/a and empty cells are skipped. Count how many cells in B2:B7 contain a number, in D2
  2. Count with a condition: COUNTIF. COUNTIF counts the cells that meet a condition. It has two parts: where to look and what to count. Count how many invoices are "Paid", in D2
  3. COUNT or COUNTA?.
  4. Part of a word: wildcards. The asterisk * stands for any text. "*chair*" finds chair at the start, in the middle or at the end. Count in C2 how many products have “chair” in their name
  5. Two conditions: COUNTIFS. COUNTIFS counts the rows that meet all your conditions, one range with one condition at a time. Count the Paid invoices from the North region, in D2
  6. Count unique values. UNIQUE makes a list with each name once, and COUNTA counts that list. Requires Excel 365 or 2021. Count in C2 how many different customers placed an order

← All lessons