Thanks Bif, I was omitting the '&' bewteen the symbol and cell reference!

"T. Valko" wrote:

Assume G1 is the linked cell:

=COUNTIF(A1:A10,""&G1)

Biff

"skewey" wrote in message
...
Hi,

I am trying to use the countif function to count the values in a range
that
are greater than the criteria which is a value in the cell link from a
psinner. The spinner was selected from the forms toolbar.

Uisng MS Exzcel 2000

Thanks.