If you just add a row at the end of a table then Excel will not adjust
its formulas - the trick is to Insert a row within the table.

Alternatively, you might like to use dynamic ranges, which
automatically adjust to suit the amount of data you have. If you want
to take this route, here's a couple of references you might like to
study:

http://www.contextures.com/xlNames01.html#Dynamic

http://www.cpearson.com/excel/named.htm#Dynamic

Hope this helps.

Pete

On Nov 5, 4:33 pm, KelliInCali
wrote:
Thanks for the reply Pete. Yes, calc is set to auto. The formula is
operating, but it is not accounting for the additional rows when either of
the tables above it auto-inserts a new row. It is behaving as though it's
range is absolute when it's not. -kelli



"Pete_UK" wrote:
Is your sheet set for manual calculation? Press F9 to see if this
recalculates, and if it does click on Tools | Options | Calculation
tab and click on Automatic.

Perhaps the format of the cell has been set to Text - click on Format
| Cells | Number tab to check, and set it to General. Double-click the
cell as if to edit it, then press <enter to bring about the change in
format.

Hope this helps.

Pete

On Nov 2, 9:36 pm, KelliInCali
wrote:
I have a formula that is outside of a list (sorry... TABLE in 2007). It is
set to total a column which spans the rows of two separate lists. The
formula range is not fixed, but the row # is not increasing when either of
the the lists auto-add rows. It always worked with the old version. Any
help?- Hide quoted text -

- Show quoted text -