| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use function output as a cell reference
I want to use the cell reference generated by ADDRESS as the number value
(start of the range) in the SUM function. For example the result of my ADDRESS function is $C$5 and I want the range in SUM to start at $C$5 to an end reference. However, when I point to the cell which contains my ADDRESS function and shows $C$5 as the result, the SUM function just takes the cell reference of where the ADDRESS fucntion is and not the outcome. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I know which cell a function is called from? | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Using SUMIF Function with a named cell reference as value in CRITE | Excel Worksheet Functions | |||
| Highlighted Reference Cell for a Working Cell | Excel Worksheet Functions | |||
| indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
Threaded Mode
