Count number of cells with any value (string or number) in a column in Google Docs Spreadsheet

google-sheets google-docs
steakpi picture steakpi · Feb 7, 2014 · Viewed 105.8k times · Source

I have several columns in Google Spreadsheet.

I would like to count how many cells have a value (number or string) and display that number at the top of the column.

For example:

Hello
World
123
Some string

The above column would give me the answer of "4"

I have not managed to find a formula that does this.

Answer

Stryder picture Stryder · Feb 7, 2014

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.

Related questions

How to define global variable in Google Apps Script

I see most examples from Google is they use only functions in a single giant script. e.g. https://developers.google.com/apps-script/quickstart/macros But in our style, we usually write all functions under a single namespace, such as …

Read More
Axis scale in google charts (from google spreadsheets)

I've generated chart form google spreadsheets. In my report for horizontal axis I have values: 1 ,2 ,3 ,4 ,5 ,10 ,20 ,30 ,40 ,50 ,100 ,200 ,300 ,400 ,500 ,600 ,700 ,800 ,900 ,1000. Chart interprets them as a labels, not a number: So the distance between 1 and 4 is the same as between 20 and 50. How to change it? (Maybe …

Read More
Get first item from Split()

I use the SPLIT function to split a string which looks something like 1.23/1.15. Right now it yields two cells, as it should. But how do I get a certain element from the result? I would like to do something like …

Read More