How to count cells with numbers in Google Docs Spreadsheet?
Count function is used to find the number of cells that contains only numeric values and it displays 0 for other cell formats like text,date,etc,.
Step 1: Click Insert → Function → COUNT
Step 2: By default, "=COUNT()" will be filled in the cell as displayed in the image below
Step 3: Just click and drag the cells. By releasing the mouse, result will be displayed.
Step 1: Click the arrow near Summation icon and select "COUNT".
Step 2: Select the cell range and the result will be displayed. Here, we have selected the cell range from A2 and A6 and copied the formula from A9 and pasted in B9 and C9. Hence the result is displayed as 7,0,0 as first column consists of only numeric values, wherein other two columns is a mixture.
Option 3: Type "=count(", select the cell, type ":" and select the another cell and then type ")"