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