I don't understand your better example.

"100 of 400 on 4 sheets and in columns of 20"

4 sheets of 4 columns of 20 would be 80 per sheet or are there 5 columns of 20
per sheet?

If D1 is supposed to be a running total of A1:C1 then your addition is
incorrect.


Gord


On Wed, 27 Feb 2008 13:58:42 GMT, wrote:

OK that formula works good but I didn't explain that I have 100 of the 400
on 4 sheets and in colums of 20.
Here is a better example:

A B C D

30.24 30.24 30.12 90.48
30.12 60.36 30.58 121.06