Sorry Richard, Ióst your email address.

Here's my comment:

page 5 page 6


amount $ amount $
1400 452
5000 77
2400 64
752 11437 <-- from A13: =A13
1885 90



sum of G5:G9 sum of I5:I9
11437 <-- =SUM(G5:G9) 12120 <-- =SUM(I5:I9)

Any change of a value in the page 5 range G5:G9 will change the sum in
A13 which will change the according value in the page 6 range I5:I9
which will change the sum of the page 6 values in D13.

If in this context you get wrong results it my have to do with the
autosum feature.

Please let me know if it works.

Hans