SUM Bins of Data

  • Thread starter Thread starter mluetkem
  • Start date Start date
M

mluetkem

Anyone know how to sum bins of data, sort of consolidating. I have a
column of per minute data that I need to consolidate down to per
10-minute bins, so for each 10 rows of per minute data would create a
single row of 10-minute data.

Thanks.
 
Maybe you could use a helper column.

=CEILING(A1,1/24/6)

[=CEILING(A1,1/24/60) will round up to the nearest minute. So I multiplied by
10.]

Will round up the time in A1 to the nearest 10 minutes.

Then you could use a pivottable to summarize this or even Data|Subtotal?????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolication of data 3
SUM Bins of Data 1
Eliminate unused columns 3
row-indirect functions 3
Link Worksheets Into Master 5
Consolidating Rows 2
Consolidating data - removing consolidation 1
Assign blank cells in a column with a value of 1 for sum purposes 3

Back
Top