Works for me. Do you have a sheet called Data?

--

Vasant

"Todd" wrote in message
...
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