Static Range Reference

[moore.mike0342]

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)?

 

[Khoshravan]

One way is to use Indirect to produce a fixed text for range.
In B1=enter A10 as your staring point of your range
In B2=enter A50 as your ending point of your range
then in B3=SUM(INDIRECT(B1):INDIRECT(B2)),
This will produce sum(A10:A50) and by deleting a row between A10 and A50,
the sum command will not change.
Hope this helps.