| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference in formula
I am trying to put in a cell reference into a a countif formula. As
referenced below, I would like to insert the formula from D37 into the formula in E37. As the formula in D37 equals 37, I am trying to paste this formula over the number "37" in cell E37. However, this isn't working. Any help would be appreciated. E37: =ROUND(1/COUNTIF($C$37:$C$58,C37),2) equals 0.5 D37: =MATCH(B37,$B$1:$B$2259,0) = 37 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| Cell Reference Embedded in Formula | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
