In columns B and C we have the time and number of cars passing.
The objective: find the max total of the sum of 7 consecutives numbers
At present we have to split out the sum of 7 consecutive numbers (column G7-10) from data and then max those in G16. Is there a way to combine this to deliver the same result in a single cell formula?
The objective: find the max total of the sum of 7 consecutives numbers
At present we have to split out the sum of 7 consecutive numbers (column G7-10) from data and then max those in G16. Is there a way to combine this to deliver the same result in a single cell formula?