Spinner, cell link and countif

[Guest]

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.

 

[T. Valko]

Assume G1 is the linked cell:

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

Biff

 

[Guest]

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