There are times when you might want to know how many times an item is repeated in another list. You can easily find this out using the COUNTIF function in Microsoft Excel 2016.

How to Get the Count of item from a List in Microsoft Excel ?

The COUNTIF function lets the users to count the data which meets a specific criteria.

The syntax is like this

=COUNTIF(<Range of Data or List>,<Item to search>)

In this example , lets say the cells D5 to D12 contains the list of cities with repetition and you would like to know hoe many times the city Bangalore is repeated.

You can use the below formula to get this count.

=COUNTIF(D6:D13,G6)