A function[1] in a spreadsheet that counts the number of cells that meet a single or multiple criteria, for example, the number of cells in the range[2] C2:C11 whose value is greater than three and less than 12.

Terms definitions
1. function. A named section of a computer program that performs a specific task. Functions help make code more efficient and reusable. They may take input parameters and produce output. « Back to Glossary Index
2. range. A selection of items. When asked in the context of an achievement standard it means at least three. In spreadsheets range is a way of selecting a group of cells. A colon is used to separate the starting and ending cells. e.g. B4:F10 « Back to Glossary Index