Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.

Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.

Merge Cells/Rows/Columns and Keeping Data Split Cells Content Combine Duplicate Rows and Sum/Average.

Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.

The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% If you want to have a free trial (60-day) of this utility, please click to download it, and then go to apply the operation according above steps. Click the OK button and all qualified cells are selected at the same time.

Then a prompt box pops up to tell you how many cells matching the condition.

In the Specific type section, select Contains in the drop-down list, enter Apple in the text box.

Select Cell option in the Selection type section.

In the Select Specific Cells dialog box, you need to: Click Kutools > Select > Select Specific Cells.ģ. Select the range you want to count number of cells containing specific text.Ģ. Please do as follows.īefore using the Kutools for Excel, you need to take minutes to free download and install it firstly.ġ. You can even countif with OR or And condition as you need with this feature.

With the Select Specific Cells utility of Kutools for Excel, you can quickly count if cell contains text or part of text with clicks. Tip: Besides the above formula, here introduce an awesome feature to easily solve this problem. If you want to directly typing the text in the formula to count, please apply the below formula:.You can change the reference cell and the criteria in the formula as you need. D5 is the cell reference containing what you want to look for. In the formula, B5:B10 is the range of cells you want to count.Criteria (required): A number, expression, cell reference, or text string that determines which cells will be counted.Range (required): The range of cells you want to count.And then drag the Fill Handle down to get all results. Select a blank cell (such as E5), copy the below formula into it and then press the Enter key. The COUNTIF function can help to count cells that contain part of text in a range of cells in Excel.

Count cells contain part of text (partial match) with the COUNTIF functionĬount cells contain text with the COUNTIF functionĬount if cell contains text or part of text with an awesome featureĬount if cell contains text or part of text with the COUNTIF function

Countif excel