How do I enter a formula that will update as more rows are added?

C

ChuckT12624

Lets say I'm going to add information every week to Column E and I don't want
to have to go to the SUM formula and edit it every time to include the new
columns I've added. Is there a way to put =sum(e6:ex) rather than =SUM
(E6:E20) so that the formula will continually expand with my new entries?
 
A

Ashish Mathur

Hi,

Convert the range to a list (Data > List > Create List), When you do so,
then the range will be surrounded by a blue border with auto filter drop
downs. Also, when you add more rows to the range, the rang will be modified
in the formula

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
S

ShaneDevenshire

Hi,

Assuming that there is no data below the range you want to sum, say E1:E20
you can modify the formula to read:

=SUM(E1:E10000)

The results will change as you add new data. Empty cells and text entries
are ignored by this function.
 

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

How to Update SUM formula after inserting rows 2
Block copy/insert of 5 rows, then update formula below? 2
Formula that will increase an integer added to a value based on.. 0
How do I calculate a specific formula for price increases? 3
how can I copy/paste a formula that skips 27 rows? 0
How do I subtotal specific / random rows from a spreadsheet? 1
How do I find & replace pieces of a formula? 5
how can I start and stop a sum formula? 1

Top