Hi there,

I have some traffic count data from a number of traffic lanes at an intersection that are split into 15 minute increments over a the course of a day. What I need to find is the maximum sum of traffic counts over an hour period (4 rows) for any one column of data.

i.e. The formula should return 19 (maximum sum of 4 consecutive rows = 5+9+2+3)

A B
0:15 1
0:30 5
0:45 9
1:00 2
1:15 3
1:30 1