Group ever 4 rows with over lap

Viewed 33

Sorry for the vague title but I'm not sure how to phrase the question. What I want to do is sum a column in groups if every 4 records, but the groupings will overlap

 Game       Strikeouts
    1.                 25
    2.                 10
    3.                 10
    4.                 11
    5.                 16

Show the first group would be games 1-4 and sum would be 56, second group would be 2-5 and sun would 47, and so on all the way down to the last record.

2 Answers
Related