Whenever I think of counting, I think of The Count from Sesame Street. He loves to count. And, he counts everything. When storing data in a Sheet, you may want to count how many students answered “True” to a question or how many parents indicated they are available to chaperone a field trip. Rather than counting each row manually, use the CountIf function:
For example:
=CountIf(J2:J100,”True”)
Click here to view a brief video on this cool Sheets feature!

Google Certified Trainer