=SUM(INDIRECT("A10:A50"))
--
David Biddulph

wrote in message
...
How can one create a range reference that contains the same number of
rows even if someone deletes rows (example a10:a50 remains the same
range reference after someone deletes rows within this range)?