# Need to Find the Maximum Sum of Four Consecutive Rows in an Array

1. ## Need to Find the Maximum Sum of Four Consecutive Rows in an Array

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  Register To Reply

2. ## Re: Need to Find the Maximum Sum of Four Consecutive Rows in an Array

Hi smotown,

You can use below formula in column C:-
=SUM(B2:B5)
and drag it down, now top of this i.e., in cell C1, you can use below formula:-

=MAX(\$C\$2:\$C\$1048576)

which will give the max sum of 4 consecutive rows.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>  Register To Reply

3. ## Re: Need to Find the Maximum Sum of Four Consecutive Rows in an Array

Or try this
Formula:  `Please Login or Register  to view this content.`

comfirmed with ctrl+shift+enter (not just enter)  Register To Reply