Suppose you want to find out how many times particular text or a number value occurs in a range of cells. For example:

If a range, such as A2:D20, contains the number values 5, 6, 7, and 6, the number 6 occurs two times.

If a column contains "Buchanan", "Dodsworth", "Dodsworth", and "Dodsworth", "Dodsworth" occurs three times.