Hi,

I have a list of data numbers in Column B and would like to sum them as follows in column D:
D2 = Sum(B2:B97)
D3 = Sum(B98:B193)
and so on..
I would like to be able to drag the formula down because I have 35042 numbers to break into 365 or so blocks so obviously don't want to type them all out by hand.

Any help would be greatly appreciated!!