+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    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. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    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>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

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

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


    comfirmed with ctrl+shift+enter (not just enter)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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