How do I get SUMPRODUCT to notice the new data I add to my workshe

[forevertrying]

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!

 

[Pete_UK]

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

Pete

 

[Don Guillett]

I noticed your LATER POST first. Please be patient when posting.