HomeGoogleGoogle SheetsUsing the CountIF Function

13.13. Using the CountIF 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.


9 STEPS

1. The Count If function can be a great way to add up specific data within a larger data range. First, open a Google Sheet and select the cell in which you want to place the function.

Step 1 image

2. Click Insert

Step 2 image

3. With your mouse, hover Function

Step 3 image

4. With your mouse, hover All►

Step 4 image

5. Scroll down and click COUNTIF

Step 5 image

6. In the COUNTIF Function, the first info in the parentheses should be the range you want to pull data from, the second should be the condition that needs to be present in order to count. We used "Taxi" to count up the total expenses from Taxi's

Step 6 image

7. As you can see, there were two expenses from taxis in the data set. If we wanted to count based on different conditions, some examples can be seen in Column D, rows 18, 22, and 26.

Step 7 image

8. Click highlight

Step 8 image

9. That's it. You're done.

Step 9 image

Here's an interactive tutorial

https://www.iorad.com/player/1740061/Docs-Google---How-to-untitled-task-name


Downloads

Knowledge Tags