The COUNTIF function is used to count the number of cells that contain a given value. The COUNTBLANK function counts the number of blank cells in a range. In this video I demonstrate how to use both functions in a spreadsheet that is used to organise a party