=COUNTIF(A1:F100,H1)

where H1 holds the value you want to count

adapt to fit your real data


--
Regards,

Peo Sjoblom



"monkeytrader" wrote in message
...
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.