Count cells that Contain text

  • Thread starter Thread starter andibevan
  • Start date Start date
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
 
=COUNTIF(Range,"*ACT*")


--

Regards,

Peo Sjoblom

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