Your formula works for me, so long as I have a sheet named Data. You have a
few needless sets of (), but they don't interfere with the formula.

=SUM(INDIRECT("Data!"&ADDRESS(55,5)&":"&ADDRESS(55 ,64)))

"Todd" wrote:

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