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