Automatic update of the list range in DSUM

[Paul Smith]

Dear All

I have a list with some data and related with that list I use DSUM.
However, whenever I add lines to the list, I have to redefine the list
range in DSUM. Can one do that automatically, i.e., can the list range
be automatically updated in DSUM whenever the list range changes?

Thanks in advance,

Paul

 

[Dave Peterson]

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

 

[Paul Smith]

I have a list with some data and related with that list I use DSUM.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

Thanks, Dave, for your help.

Paul