# 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

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>

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)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1