Topics Map > Office 365 > Excel
Microsoft Excel - Count how often a value occurs
Note: The screenshots in this topic have been taken in Excel 2016. Depending on your Excel version, the screen may appear different, but the functionality will still be the same.
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.