A group of six children do a test. How many achieve higher than the threshold (in the example, 15)?

This is a simple example of the powerful array formulae. Don’t forget to press CTRL + SHIFT + ENTER rather than ENTER when finished.