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.
2. Click Insert
3. With your mouse, hover Function
4. With your mouse, hover All►
5. Scroll down and click COUNTIF
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
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.
8. Click highlight
9. That's it. You're done.