One way is to INSERT before the bottom instead of adding at the bottom.
Another is to use a defined name for the range that will make it self
adjusting such as myrng and the formula
=offset($a$1,1,0,counta($a:$a)-1,10)
To do thisinsertnamedefinename itin the formula type in the offset
formula.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"forevertrying" wrote in message
...
Hello,

This page has been extremely helpful over the last two weeks, but I can't
find anything relevant to help me out with this one.

I have created a database of information from which, using sumproduct, i
can
gather around 54 different figures which saves me an awful lot of time.

Unfortunately, in my practice run with it, I have found that when I add
new
information to the bottom of the database worksheet, it sends all of the
figures to #VALUE. It doesn't seem to want to change the range for each
array
to the same number. The last one is always different to the rest and I
don't
know how to fix it. so far, everytime I add new information I am having to
do
a 'Find and Replace' on all the formulas to update it all. Surely there
has
to be an easier way?

Thanks