Thread: Sum query

Hello

I have a query about sum. I am trying to work out culmulative totals of two rows of numbers.

In row 4 between cells G4 and W4 there is the following numbers:

2 3 3 4 4 4 4 4 4 3 3 3 3 3 3 0 0 0

These represent monthly profiled figures. Below this is another row of actual figures. At present this row starts at G5 and continues to K5. The numbers in this row are:

0 2 0 4 11

I would like to have culmulative totals for each of these rows in D4 and D5 respectively. Where only 5 cells (i.e. 5 months figures) have been input into row 5 I only want the culmulative total of row 4 to sum the first 5 months figures. And then when I add more more actuals into row 5 then the culmative total of row 4 should also increase.

Hopefully someone can make sense of that and help me out.

cheers

dean

Thank you very much, that's worked a treat.