Formula in Range name

[howard]

I have created a range name Disc and used the formula below for the range name

 =sum(TB!$F$501:$F$502)

The data on sheet "TB" is imported and the rows can change when new data is added


I would like to know how to set up my range name formula so that the data pertaining to my range name "Disc" always sums the correct range

 

[Aladin Akyurek]

Define TBrange in the Name Manager as referring to:

=TB!$F$501:INDEX(TB!$F:$F,MATCH(9.99999999999999E+307,TB!$F:$F))

Then:

=SUM(TBrange)

if you didn't of course imply vba.

 

[howard]

Thanks for the help

 

[Aladin Akyurek]

Thanks for the help

You are welcome.