How do I count cells containing text values in Excell

R

Ross Stanton

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?
 
T

Toppers

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
 
Top