COUNT
Counts the number of cells that contain numbers. Does not count empty cells, text, or error values.
COUNT(value1, [value2], ...)Arguments
value1The first cell or range to countvalue2Additional cells or ranges to count(optional)
=COUNT(A1:A10)Counts how many cells in A1:A10 contain numbers
=COUNT(1,2,"text",4)Counts only the numeric values (ignores text)
=COUNT(A:A)Counts all numeric values in column A
- •Use COUNTA to count all non-empty cells including text
- •Use COUNTBLANK to count empty cells
- •Dates and times are counted as numbers
- •Using COUNT expecting it to count text entries too - it only counts cells containing numbers
- •Confusing COUNT with COUNTA, then wondering why text-based entries like names aren't showing up in the total
- •Counting a range that includes dates or times without realizing they're stored as numbers, so they get counted like any other number
COUNTACounts any non-empty cell, including text - use this if you need to count everything, not just numbersCOUNTBLANKCounts empty cells instead of filled onesCOUNTIFCounts cells that meet a specific conditionWhat's the difference between COUNT and COUNTA?
COUNT only counts cells containing numbers. COUNTA counts any cell that isn't empty, including text, dates, and logical values.
Does COUNT include a cell with a formula that returns an empty string?
No - a formula returning "" looks empty but is technically text, so COUNT skips it, while COUNTA would still count it.
Can COUNT tell me the total number of cells in a range?
Not directly - it only counts numeric cells. For the total number of cells regardless of content, use ROWS(range)*COLUMNS(range).
Need to translate a formula using COUNT?
Use our translator to convert your complete formula