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!

Julianne Lange on Email
Julianne Lange
Trainer/E-Rate Specialist @ Northern Buckeye
Google Certified Trainer