| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summing a range using INDIRECT & ADDRESS
I am trying to sum a range on the "Data" sheet. I will actually be using the
MATCH function within the ADDRESS function to ultimatly identify the range to sum. But I cannot even get this fuction to work. It gives the #Ref! error. =SUM(INDIRECT("Data!"&(ADDRESS(55,5))&":"&(ADDRESS (55,64)))) Thanks for any help. Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
| Indirect range in SUMPRODUCT? | Excel Discussion (Misc queries) | |||
| summing part of cells in a range | Excel Discussion (Misc queries) | |||
| Address of named range | Excel Worksheet Functions | |||
Threaded Mode
