Wednesday 8 May 2019

Google Spreadsheets: Using COUNTA and COUNTIF

There are many times that I need to create a spreadsheet that houses the organisation of school wide events like Fiafia or even a camp. One of these sheets that I create often is a payment sheet to track who has paid, who has handed in their permission/ medical forms and if I have emergency contact details for any child.

What I hate with these types of sheets is not being able to know at a glance - especially when they get large like our year 5&6 camp (around 150 kids) you can't tell easily how many kids you need to follow up. So I use the two formulas to do this for me: COUNTA and COUNTIF.

Check out this screen recording to learn how to do it.

No comments:

Post a Comment