# How to Count Specific Text in Excel

To count specific text in Excel is not a difficult task. It can be done via the famous COUNTIF formula. Previously, we have used COUNTIF formula under two cases as follows:

How to Count Specific Text in Excel

In order to do this task, you can use the following formula:

=COUNTIF(\$C\$4:\$C\$13,"*1995*")

Explanation

The first part in the brackets are the range in which Excel will search for the required data which we have inserted in the inverted commas. So, the formula is self-explanatory.

Example

We have been given following data for the students of a school:

 S. No Student Reg # 1 John 2006UTIL 2 Cena 2006HXYT 3 Kalim 2007ZTUS 4 William 2009HGTL 5 Jagdesh 1999FTHE 6 Salman 2003HGSA 7 Rose 2001HGTL 8 Sita 1995GBTL 9 Bill 2003BGVF 10 Michael 2015TRFQ

We have been told to produce a report that shows up number of students registered in each year. Apparently, this task seems quite difficult and time consuming, but this can be done via the power of COUNTIF within few minutes.

As you can see that we have used the COUNTIF formula in above Excel workbook. First, we mentioned the range at which Excel find the data according to the criteria set in next part which is under inverted comma.

Contents