finding the highest total for a consecutive group of entries in a column - EXCEL

Question

rather then finding the highest single entry, i want the highest total for a consecutive group of n entries e.g within a column of 100 values i want to look to find 10 consecutive cells whose sum is a maximum

I say 10 as an example i wish to be able to change that easily.

Answer 1

With data in A1 through A100, in B10 enter:

=SUM(A1:A10)

and copy down through B100

Then in another cell, use:

=MAX(B:B)