Count number of cells with any value (string or number) in a column in Google Docs Spreadsheet
In the cell you want your result to appear, use the following formula:
=COUNTIF(A1:A200,"<>")
That will count all cells which have a value and ignore all empty cells in the range of A1 to A200.
You could also use =COUNTA(A1:A200)
which requires no conditions.
From Google Support:
COUNTA counts all values in a dataset, including those which appear more than once and text values (including zero-length strings and whitespace). To count unique values, use COUNTUNIQUE.
An additional trick beside using =COUNTIF(...) and =COUNTA(...) is:
=COUNTBLANK(A2:C100)
That will count all the empty cells.
This is useful for:
- empty cells that doesn't contain data
- formula that return blank or null
- survey with missing answer fields which can be used for diff criterias