Summation of every 6 rows

[SimulationsonSimulations]

Hello I am running extensive simulations on 6 processors therefore my output data every timestep is divided into 6. Considering that there is a lot of timesteps close to a million, I need to be able to add 6 rows at a time.

Example:
timestep value
2 1
2 2
2 4
2 0
2 1
2 5

Any one have any ideas on how i could do this on excel§?

 

[Andrew Poulsom]

Welcome to MrExcel.

Where do you want the formulas? It may help to see some more sample data.