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
Financial Ratios Accounting Cycle Accounting Principles Financial Accounting Basics Financial Statements Reporting Bad Debts Current Assets Long-term Assets Voucher System Partnership Depreciation Work Sheet - 10 Column Work Sheet Difference Between Reserve and Fund Accounting for Leases Capital reduction and reconstruction Absorption of Company Amalgamation Accounting for Installment Sales Basis of Recording Profit and Loss Branch Accounting Construction Contracts Revenue Recognition Accounting for Groups Financial Analysis Events After the Balance Sheet Date Deferred Tax Cost Accounting Activity Based Costing (ABC) Throughput Accounting Relevant Cost Break Even Analysis Standard Costing Inventory Management Payroll Accounting Royalty Accounting Statistics Master Budget Salary Income Microsoft Excel Tutorial How to Count Number of Records between Two Dates How to sum values in excel based on a criteria Finding the first login and last logout time of employees How to Print Salary Slips Using VLookup Formula in Excel How to Calculate Net Present Value (NPV) in Excel Income tax calculation excel sheet for salaried individuals How to Calculate Pay Back Period in Excel How to Calculate Declining Balance in Excel Using Formula How to Calculate Double Declining Balance in Excel How to Calculate Number of Payments on A Loan In Excel Using NPER Count the Number of Excel Records That Fall Between Two Dates How to Count Cells between Two Numbers in Excel How to Prepare Exam Result in Excel 3D Sum Multiple Worksheets How to Count Specific Text in Excel Other Topics Share or Stock Valuation Model Financial Management Topics Kinds of Endorsement Letter of Credit, Kinds and Its Advantages/ Utilities Modern Functions of a Commercial Banks Difference Between Secured And Unsecured Loan Excel conditional formatting red if negative green if positive How to Remove Extra Spaces in Excel Result Card or Result Sheet Creation Using Excel Basic Accounting MCQS Multiple Choice Questions