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