Extend range to sum

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I want to have cell C1 display the sum of an unknown number of cells in
column D. The list in column D will grow over time. How can this be done
without specifying a range much larger than I currently need?

Ivor
 
Can you use the whole column?

=sum(d:d)

Excel is smart enough not to actually have to check each of those 65536 cells.
 
Back
Top