i think i need count function help

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

Guest

i need a function to count how many times a symbol occurs in a list.

example of list of symbols:

abc def ghi jkl mno qxr
qxr mno jkl ghi def abc
abc def ghi jkl mno qxr
abc abc abc abc abc abc

would like to show for example, how many times "abc" occurs, "def", etc.

thanks in advance for your help.
 
=COUNTIF(A1:F100,H1)

where H1 holds the value you want to count

adapt to fit your real data
 
Back
Top