Automatic update of the list range in DSUM

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

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

Paul Smith wrote:
>
> 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

>> 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?
>
> See Debra Dalgeish's site for some nice tips:
> http://contextures.com/xlNames01.html#Dynamic

Thanks, Dave, for your help.

Paul