Try this:

Data in A1:A5

C1 = number to count

=SUMPRODUCT(--(ISNUMBER(FIND(" "&C1&" "," "&A1:A5&" "))))

Biff

"Gil Vargas" <Gil wrote in message
...
I'd like to see if I can set up a counting system for counting the number
of
occurances in a series of cells. For example, I have a row with the
following (it's a team schedule):

1 x 3
5 x 10
3 x 9
11 x 12
4 x 5

I'd like to see how often a number would appear. In this case, the number
1
would appear 1 time, the number 3 appears twice.

Thanks,
Gil