The COUNTIF function counts how many of a range of cells contain a certain value.
This drill to accompany the GCSE Double Award in Applied ICT gives a good example of how to use the COUNTIF function.