Cumulative backwards sum

[alepaladio]

Hi everyone, I have an issue, how can you, using excel vba 2010 do a sum of the elements of a column backwards, i have this

Sum		0.7447
Sum by 1/3		0.2482
0.0980	0.7448	0.0730
0.2000	0.7448	0.1490
0.2627	0.7448	0.1957
0.1804	0.7448	0.1344
0.0863	0.7448	0.0643
0.0941	0.7448	0.0701
0.0431	0.7448	0.0321
0.0235	0.7448	0.0175
0.0118	0.7448	0.0088

<colgroup><col width="80" span="3" style="width:60pt"> </colgroup><tbody>
</tbody>

where value 0.7447 is the sum of last column, and sum by 1/3 is 0.7447*1/3

what I need, is to make a sum, starting from last value in last column (Cells(11,3)), and stop when it is greater than sum by 1/3. I have this...

For i = 8 To 0 Step -1
Cells(11 - i, 4) = i
Next i


this helps me count from 0 to 8 backwards, but I dont know hot to make the cumulative sum, until It reaches 0.2482, please help!

Thanks for your help!

 

[igold]

In your example the sum of the last column is 0.7449 not 0.7447

 

[alepaladio]

In your example the sum of the last column is 0.7449 not 0.7447

i have more decimals in my document that makeit go to that value.... do you have any more suggestions? :D

 

[igold]

I will look tomorrow, I wanted to make sure we were on the same page before I went any further....