None of us are mind-readers - post your formula with examples of data
that is causing the problem.

Pete

On Apr 11, 12:16*pm, forevertrying
wrote:
Hello,

I have been reading through all your posts and and have found them to be
very helpful with the worksheet I have set up so far, up until this moment..

I have created a record of works that now produces a worksheet of
automatically calculating sums based on several criteria.

The problem I have is that when I add a new line of data to the main
spreadsheet of data, the SUMPRODUCT formulas I've put in on the worksheet
that adds them all up will only show #VALUE in all the boxes that had figurs
in. I have had to go through and manually change the formula to include the
latest row of information.

I don't know if this makes enough sense to anyone for them to be able to
help, but I would really appreciate it if you can.

Also, i tried changing the record of information to a list, but this didn't
prevent the #VALUE thing either.

PLEASE HELP!!!!!! I've spent two weeks on this alreayd, and apart from this
last thing I think I've about achieved my aim!