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!

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!

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"forevertrying" wrote in message
...
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!