Adjacent cells - setting criteria for "A" while averaging "B"

**ilovemonkeys** · 02-09-2013, 11:24 AM

Hi all,

I have two columns in excel, A and B, and A contains times in the 0-24 hour format. The adjacent column, B, has data that correspond to each particular time.

What I am trying to do is sort through column A to find the averages of the values for each particular point in time (the times are roughly every 5 minutes for 24 hours). The attached example is only a snip-bit of the actual worksheet, which has up to 700 values down the column.

Thank you!

Example_plot.xlsx

**Andrew-R** · 02-09-2013, 11:28 AM

Something like this, maybe:

=AVERAGEIF(A:A,TIMEVALUE("00:55"),B:B)

Obviously you can adjust the value inside the TIMEVALUE function to suit whichever time you want the average for.

**ilovemonkeys** · 02-09-2013, 11:57 AM

Never mind, I just had to save the file. Thank you so much for your help!

I made a column in E that has the various times in it (00:55, and so on) so i pasted the formula next to this column, deleted the time value("00:55"), and replaced it with the link to the adjacent time cell. I tried dragging this formula down the new time column to adjust all of these values, however the cells would not update themselves even though the formula within each adjusted for the adjacent time.

Attached I have a file of what I'm referring to.

Example_plot.xlsx