How to Count Number of Cells in Excel?

Use `=COUNT(range)` to count cells containing numbers

Use `=COUNTA(range)` to count non-empty cells

Use `=COUNTBLANK(range)` to count empty cells

Use `=COUNTIF(range, criteria)` to count cells meeting one condition

Use `=COUNTIFS(range1, criteria1, range2, criteria2)` to count cells meeting multiple conditions

Select a range and look at the status bar for a quick count of numeric cells

Use the Name Box to select a range, then check the status bar for count results

Use a PivotTable to count items in a field

Use `=ROWS(range)*COLUMNS(range)` to count total cells in a rectangular range

Use `=SUMPRODUCT(–(range<>“”))` to count non-empty cells in more complex ranges