Sum

Hi hope someone can help

I have two columns and the data is sorted in ascending order using column A. What I would like to do is find the largest sum of consecutive numbers in column B (whether that is a single cell, or all the cells). Looking at the data below I have manually highlighted the highest sum of consecutive cells. Is there anything I can use that would do this automatically?

See attachment.

I am sure it is dead easy I can't do it
cheers!

Hi,

I don't understand something, so perhaps you can clarify.

As far as I can see, the highest consecutive sum is B9:B23, which is a sum of 15.15.

But you have highlighted B9:B15, which is a sum of 12.15.

Is that a mistake or have I misunderstood the question?

Hi,

In the scenario that multiple sequences all give the highest cumalitive sum, which cells should be highlighted?

eg. If you had 1,-1,1
The highest cumulative sum is 1. That could be the first 1 or the last 1 considered individually, or it could be all three considered togther.

or, if you had
1,2,-1,1,-10,1,1,1
The highest cumulative sum is 3. This could be either the first two numbers, or the first four numbers, or the last three numbers.

Okay, last question then. What if two separate sequences have the same length?

eg. 1,1,1,-10,1,1,1

Which should be highlighted?

To account for all these features I think we're looking at a VBA solution. If that's acceptable for you then I'll try to put something together for you this weekend. Approximately how many items do you expect there to be in the column?

Try the attached.

an image SHG?

Image in, image out ...

i thought as much lol

Forgot about this ...