Formula to Count keywords in cells

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a spreadsheet that has a Column I want to contain either of the
following words "STOCK" or MODERATE" or "EXTREME".

I want to get a count of each Value and place that in a different Cell

I know it can be done I just cant seem to get the proper syntax.

Can someone show me how??
 
One way:

=COUNTIF(I:I,"STOCK")
=COUNTIF(I:I,"MODERATE")
=COUNTIF(I:I,"EXTREME")

if the words might show up with other words in the cell:

=COUNTIF(I:I,"*STOCK*")
etc.
 
Back
Top