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.