ExcelBanter - How do I count cells containing text values in Excell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I count cells containing text values in Excell (https://www.excelbanter.com/excel-worksheet-functions/131317-how-do-i-count-cells-containing-text-values-excell.html)

Ross Stanton

How do I count cells containing text values in Excell

I am trying to count the cells in a given range containing a certain text
value in an Excel 2000 spreadsheet. Is there a way to do this?

JE McGimpsey

How do I count cells containing text values in Excell

One way:

=COUNTIF(given_range, "certain_text_value")

In article ,
Ross Stanton <Ross wrote:

I am trying to count the cells in a given range containing a certain text
value in an Excel 2000 spreadsheet. Is there a way to do this?

Toppers

How do I count cells containing text values in Excell

This will count of cells containing "ABC"

=COUNTIF(A1:A10,"ABC")

This count cells where text contains ABC within it e.g. ABCDEF would be
counted.

=COUNTIF(A2:A10,"*ABC*")

HTH

"Ross Stanton" wrote:

I am trying to count the cells in a given range containing a certain text
value in an Excel 2000 spreadsheet. Is there a way to do this?

All times are GMT +1. The time now is 01:36 AM.