Knowledge Books

Home → Google → Google Sheets → Using the Count Function

13.10. Using the Count Function

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-it interactive" to select your preferred viewing method. Then, click start.


8 STEPS

1. The Count function returns the total number of NUMERIC values in a dataset (it will not count words/text). To use it, open a google sheet and 
click and highlight your desired cell in which to use the function.

Step 1 image

2. Click Insert

Step 2 image

3. With your mouse, hover Function u

Step 3 image

4. Scroll up and click COUNT

Step 4 image

5. The function is now in my cell. Now I must tell it which other cells I want it to count for me

Step 5 image

6. Highlighting your desired cells will automatically add them to the Count function's range.

Step 6 image

7. Hit enter or click out of the cell

Step 7 image

8. That's it. You're done. We now see that there are a total of 10 numeric responses between cells Q2 and Q11.

Step 8 image

Here's an interactive tutorial

https://www.iorad.com/player/1737935/Google-Sheets---Using-the-Count-function


Downloads

Knowledge Tags
Google Sheets  /  count  /  function  /  sorting  /  functions  / 

← Using the Unique Function Using the IF Function →