Consolication of data

M

mluetkem

Anyone have a quick way of taking a set of data (x value of time) tha
is presented in 10-minute bins (data point every 10-minutes) an
consolidate to 30-minute binned data sets (essentially sum every
10-minute bins to each 30-minute bin).

Thanks.

Mik
 
M

mluetkem

My data actually starts in B9, does that changes how things are done i
the formula?

Mik
 
M

mluetkem

My data actually starts in B9, does that changes how things are done i
the formula?

Mik
 
M

Mark Graesser

Hi Mike
Using the second fromula I provided you can set it up for any starting cell. For B9 the formula will be

=SUM(OFFSET($B$9,(ROW()-9)*3,0,1,1):OFFSET($B$9,(ROW()-9)*3+2,0,1,1)

Enter this on row 9 and then copy down. I made a slight change in the second OFFSET formula. The row offset is now set up to be the same value as the starting cell plus 2

After you have created the new table you can Copy and Paste_Special>Values to convert the formulas into hard numbers

Good Luck
Mark Graesse
[email protected]
Boston M

----- mluetkem > wrote: ----

My data actually starts in B9, does that changes how things are done i
the formula

Mik
 
Top