| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif with cell ref vs fixed number...
I am trying to use countif to establish whether a range of cells have a value
greater than or equal to a number in another cell - the number is 21.8% and lives in cell C4 this formula works fine =COUNTIF(C16:R16,"=21.8%") however if I try and make this work using the cell ref I get a result of zero, eg =COUNTIF(C16:R16,"=C4") Please can someone tell me what I am doing wrong, or is this a limitation of excel? Many thanks in advance for your help, griff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif cell contians a specific number (within a list) | Excel Worksheet Functions | |||
| Dividing by fixed number | Excel Discussion (Misc queries) | |||
| Addding a Random number to a fixed number..... | Excel Discussion (Misc queries) | |||
| How can i specify a cell to have a fixed number of characters | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
