| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create an Excel Update for COUNTIF Formula | Excel Discussion (Misc queries) | |||
| Is This Embedded in The COUNTIF() function??? | Excel Worksheet Functions | |||
| Multiple COUNTIF formula | Excel Discussion (Misc queries) | |||
| countif variable criteria | Excel Discussion (Misc queries) | |||
| CountIF? | Excel Discussion (Misc queries) | |||
Linear Mode
