Google Sheets - How to use COUNTIFs Function in Google Sheets

16 STEPS

1. The first step is to open a Google Sheet with data that you would like to find & display the counts and then click or create a tab to house this new information.

For this example, Click Counts.

2. Click on a cell

3. Type a Header Name and Press Enter

4. Type =count

5. Click on the COUNTIFS function

6. Click Data

7. Click on the Data Range

8. Type , & the Validation Information followed by another ,

9. Click Data Range

10. Type ,

11. Click Counts

12. Click Cell to calculate off.

13. Type ) and Press Enter

14. Click Corner of the cell

15. With your mouse, click and drag corner, then drop it on bottom corner

15b. Drop

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

Here's an interactive tutorial

https://www.iorad.com/player/1851381/Google-Sheets---How-to-use-COUNTIFs-Function-in-Google-Sheets