To count the cells with numeric data we use the formula COUNTB4B16. Asterisk - matches any sequence of characters you use it to count cells containing a specified word or a characters as part of the cells contents. Use COUNTIF function to make Excel count words or numbers in any range of cells.
But these days we often use them to store and manipulate text too.
COUNT formula can also be used with other excel functions to get the desired output. Find and Delete Duplicate cells in Excel Example 8. The powerful COUNTIF function in Excel counts cells based on one criteria. It outlines the dietary preferences of a group of people.