How do I count cells containing text values in Excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
count - but exclude counting cells with a formula 4
count nonblank cells 3
Counting Results of Formulas 1
Count values, excluding duplicates and specific values 2
How do I count cells that contain a number of charctors. 3
Help in counting and summing cells based on multiple conditions 9
COUNTIF formula 2

Back
Top