Home › Learn Excel › Lesson 2
Count numbers, filled-in cells and cells that meet one or more conditions. The last one you write yourself.
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 D2COUNTIF 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* 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 nameCOUNTIFS 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 D2UNIQUE 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