| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif with cell reference
Hi
Hope someone can help. Is there a way to count the amount of instances less than a certain value, but to enter this value as a reference to a cell. For example the following: =COUNTA(C5:C1000)/COUNTIF(B5:B1000,"h3") Does not work but if i type in the value of h3 it does. Is there no way to leave it as h3 so I dont have to manually enter it many (many!) times over? Thanks.... nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should have a absolute reference cell property. | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| international absulute cell reference | Excel Discussion (Misc queries) | |||
| Name Box cell reference | Excel Worksheet Functions | |||
Threaded Mode
