How to Extend Range Automatically

  • Thread starter Thread starter myeaddress2003
  • Start date Start date
M

myeaddress2003

Hi, if i put a formula on a column like =Sum(A1:A9) now i want that
excel make the formula extend so that if some one put value in A10 or
A110 Ecel Automatically add it . is it possible
 
Why not just have the range to its maximum value in the first place, is
this not unduly complicating things?

sum(a1:a10) returns the same as sum(a1:a1000) if a11:a1000 are blank

Regards

Dav
 
Why not just have the range to its maximum value in the first place, is
this not unduly complicating things?
Click to expand...

Just to add on a little ...
For eg: =SUM(A:A)

---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing a range of cells based on criteria in another range 2
How to stop to adjust references automatically 7
auto extend formulas 2
VLOOKUP does not work with array formula 1
Bug in Excel? 2
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET 6
Scrabble Value calculation for Welsh words 0
If data present, then display graph. 2

Back
Top