cumulative sub total, is it possible?

**arctushar** · 04-15-2010, 01:32 PM

Hello
I think its not possible. I tried myself but failed.

I have an spreadsheet containing 120 rows. as 120 rows is not possible in one a4 paper. an a4 paper can provide only 10 rows according to my row height. so I want that

there will be subtotal at the end of each page and the cumulative total will be at the first row. on detail

1st page last row contain sum of 1-10 rows
2nd page 1st row contain sum of 1-10 rows and last row contain sum of 1-20 rows
3rd page 1st row contain sum of 1-20 rows and last row contain sum of 1-30 rows

and so on
If this is possible the plz give me the solution. I want there will be headrow which is repeated row on printing.

**DonkeyOte** · 04-15-2010, 01:37 PM

It's not very clear where your data is but if we assume values are in B1:B120 and you want totals in Column A then:

A1: =IF(AND(ROWS(A$1:A1)>1,MOD(ROWS(A$1:A1),10)<2),SUM(B$1:B1)-IF(MOD(ROWS(A$1:A1),10),B1),"")
copied to A120

(modify ranges to suit but note use of $ etc...)