Thread: How do I count cells containing text values in Excell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default 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?
Reply With QuoteReply With Quote