[TABLE="width: 500"]
<tbody>[TR]
[TD]Row #[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]385[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]-732[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]244[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]457[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]436[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there a formula in excel that would identify the consecutive values that yield the highest sum ? In this simple example adding rows 3 to 5 will give you the highest total which is 1,137.
I have a list of nearly 1,000 rows and I'll need a formula to identify which consecutive rows should be added to arrive at the highest sum total.
Thanks !
<tbody>[TR]
[TD]Row #[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]385[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]-732[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]244[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]457[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]436[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there a formula in excel that would identify the consecutive values that yield the highest sum ? In this simple example adding rows 3 to 5 will give you the highest total which is 1,137.
I have a list of nearly 1,000 rows and I'll need a formula to identify which consecutive rows should be added to arrive at the highest sum total.
Thanks !