averaging time stamped data chuncks at regular row intervals

Hello all, my name is Nicholas and I'm new to this forum.

I have a problem with excel, I am trying to repeat a calculation at regular row intervals and was wondering if anyone would be able to assist me in solving this problem.

The application is a a flow meter that collects data of flow rates, and a program is used to dump the data into a spreadsheet with minute by minute time stamps.

there are 12 data points per each minute, and flow will be measured for two weeks (lots of data). I need to average 12 values for evey time stamped minute of data and then add these averages to get a totalized flow.

The easiest way i can think of to do this is if it were possible to average 12 rows, but the calculation is only applied at every 12 minute intervals (can i do this with the fill handle?). here is a graphical representation of my situation...

Time
12pts/min Data


1546 12.49 Average 22.90917
1546 12.49
1546 24.99
1546 24.99
1546 24.99
1546 25
1546 24.99
1546 25
1546 24.99
1546 24.99
1546 24.99
1546 25

1547 24.99 Average 24.47167
1547 25
1547 24.99
1547 24.99
1547 24.99
1547 24.99
1547 25
1547 24.99
1547 25
1547 24.99
1547 24.99
1547 18.74

1548 18.74 Average 18.74000
1548 18.74
1548 18.74
1548 18.74
1548 18.74
1548 18.74
1548 18.74
1548 18.74
1548 18.74
1548 18.74
1548 18.74
1548 18.74

Totalized flow so far (Sum of averages) 66.12083


I want to do that for two weeks of data, which would be a very tedious copy/paste job. If anyone could show me a way to automate this calculation for the entire data set or at regular row intervals(row 1 to 20000, say), that would be fantastic and greatly appreciated.

Thank you in advance for your help,


Nicholas Edwards
Accutech

I apologize for my confusing explaination. Here is a summary of what I am trying to accomplish.

every 12 rows represents a minute of data. I need to average every minute of data and then sum the averages.

so manually, i would do this for every 12 rows of data:

=AVERAGE(D1:D12)

=AVERAGE(D13:D25)
.
.
. and so on for the entire data set


the way the data table is set up, it would be convenient to do this calulation for every 12 row chunks of data.

After all that, i would like to sume all the averages:

=SUM(D1,D13,D25,D37...and so on for the entire data set) - intervals of 12 again

I have provided an upload of the manually (copy, pasted) calculated data so far

Thanks again for any assistance anyone could provide me.



Nicholas Edwards
Accutech

103 247 1546 12.49 22.90916667
103 247 1546 12.49
103 247 1546 24.99
103 247 1546 24.99
103 247 1546 24.99
103 247 1546 25
103 247 1546 24.99
103 247 1546 25
103 247 1546 24.99
103 247 1546 24.99
103 247 1546 24.99
103 247 1546 25
103 247 1547 24.99 24.47166667
103 247 1547 25
103 247 1547 24.99
103 247 1547 24.99
103 247 1547 24.99
103 247 1547 24.99
103 247 1547 25 Totalized Flow 171.2868333
103 247 1547 24.99
103 247 1547 25
103 247 1547 24.99
103 247 1547 24.99
103 247 1547 18.74
103 247 1548 18.74 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1548 18.74
103 247 1549 18.74 18.74416667
103 247 1549 18.75
103 247 1549 18.75
103 247 1549 18.74
103 247 1549 18.74
103 247 1549 18.74
103 247 1549 18.75
103 247 1549 18.75
103 247 1549 18.74
103 247 1549 18.75
103 247 1549 18.74
103 247 1549 18.74
103 247 1550 18.74 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1550 18.74
103 247 1551 18.75 23.95
103 247 1551 18.74
103 247 1551 18.74
103 247 1551 18.74
103 247 1551 18.74
103 247 1551 18.74
103 247 1551 18.75
103 247 1551 31.24
103 247 1551 31.24
103 247 1551 31.24
103 247 1551 31.24
103 247 1551 31.24
103 247 1552 31.24 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1552 31.24
103 247 1553 31.24 12.49183333
103 247 1553 31.24
103 247 1553 31.24
103 247 1553 6.239
103 247 1553 6.244
103 247 1553 6.241
103 247 1553 6.241
103 247 1553 6.244
103 247 1553 6.241
103 247 1553 6.244
103 247 1553 6.244
103 247 1553 6.244