Subscribe RSS FeedHow do I count the frequency of a cell range with a simplest way?
Counts the number of cells within a range
The simplest ways to count the frequency of cell range is to use COUNTIF formula.
COUNTIF (range,criteria)
Range is the range of cells from which you want to count cells.
Criteria are the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed as “Banana”, “Mango”, or “Apple” / B2.
Enter the following formula:-
COUNTIF(B2:B15,”Apple”)
After entering the formula, you will get the result of 4 which means that Apple taken 4 days in this example.
Just try to play around this formula, this formula can do more task than that example that i show. 
