Spreadsheet+Count

The following video explains the COUNT function

media type="youtube" key="nsUTFVNu9HU" height="315" width="420"

Task
A school is planning a trip to Alton Towers. The total cost of the trip is £80, so the school has broken payments into 4 installments.



A spreadsheet has been created and all data has been entered manually except for the **Paid** cells. These use a COUNT formula to count how many people have paid each installment. Recreate this spreadsheet ensuring that the COUNT function is used in cells B12 - E12.