Count cells that Contain text

A

andibevan

Is there a way in excel to count the number of cells in a colum tha
contain a specific piece of text, e.g. "ACT"

I know that I can use the countif or sumproduct functions to coun
cells which *only* contain "ACT" but I need to count the number o
cells in a column which countain ACT but may also contain other text a
well.

You can manually do it using autofilters but I need to count it using
formula.

Any help would be greatly appreciated.

Ta

And
 
P

Peo Sjoblom

=COUNTIF(Range,"*ACT*")


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 

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

Excel Countif cell has diagonal border 6
Excel Use COUNTIF across a range of cells with formulas 0
Count Dates? 5
counting text strings 1
Using COUNTIF to count explicit text that DOES NOT include other text 8
Excel Count Cells That Contain Text With "?" 0
Excel Sum numbers in cells that also contain text 34
Count of Font Format 1

Top