fill formula for summing dates in unique way

[jam320]

Hello - I'm trying to sum my years. I have a date range of 1959 to 2017 in column A. Column B is the sum of the individual numbers (e.g. 1+9+5+9=24). Column C then sums the sum of column B (e.g. 2+4=6). I have attached a worksheet that shows what I am explaining. My question is - Is there a formula that allows me to fill the column down for each column without having to manually sum each column. Thanks in advance.

[FlameRetired]

One way.
Try in cell B2 and fill across C2

Please Login or Register  to view this content.

[jam320]

That's beautiful sir. Now what would my if statement look like if I wanted the sum products 11 and 22 in b2 to stay the same as a fill across c2?

[Phuocam]

Or try in C2:

=IF(A2=0,0,MOD(A2-1,9)+1)