ExcelBanter - Spinner, cell link and countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Spinner, cell link and countif (https://www.excelbanter.com/excel-discussion-misc-queries/127765-spinner-cell-link-countif.html)

skewey

Spinner, cell link and countif

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

Spinner, cell link and countif

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.

skewey

Spinner, cell link and countif

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.

All times are GMT +1. The time now is 05:39 PM.