Try this:
=SUM(INDIRECT(ADDRESS(7,1,4,1,A1)):INDIRECT(ADDRES S(10,1,4,1,A1)))
regards,
Stefi


€žDarin Kramer€� ezt Ã*rta:



Thanks Bob doesnt seem to work - dont a need an open and close bracket
for the sum? also whats the first "" do?

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***