Google Spreadsheet: Count cells
To count cells that have value, you can use function "COUNTA". It will return the amount of cell that has value. Usage : =COUNTA( cells_range ) Example : Reference : http://support.google.com/drive/bin/static.py?hl=en&topic=25273&page=table.cs&tab=1240295