Sum a variable number of cells

Ahh. I see your confusion Martin.

I would like to sum X number of cells, where X is the variable, and in my example it is set at 5. Each cell in the second line sums 5 cells. In the second example it is set at 3, where each cell in the second line sums 3 cells. X will need to range from 1-10.

Does this make it more clear?

Thanks for following up.