Thanks Alex. I'll give it a try.
jch

"Alex Delamain" wrote:


Here's a suggestion - try using =offset() in your formulae.
For example:
If your data has column headings in row 1 add a new row above it. Then
in cell A1 enter =counta($a:$a)-2 (the -2 is to account
for the cell itself and the heading)

This will give the number of rows of data and will update when rows are
added or deleted.

For your formulae you then use this number of rows in an offset
function
=offset(reference,rows,cols,height,width)
so if column B has monthly sales starting in B3 the last 12 months
total is:

=SUM(OFFSET(B2,$A$1,,-12))

No matter how many rows are added or removed this will always sum the
last 12 rows

hope it helps


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=394062