Formula to add percentages from the next positive percentage above the given row

[lar9149]

Hello add

I wanted to create a formula that simply adds the percentages of the same row to the next positive percentage above the specified row and same column.

In the example given, I manually added the percentages of columns G-I to the percentage in column E of the given row. For example, in row 18 the percentage in column E is added to the row 16 column G making 0.717%.

To making it simplier, I just wanted to use a formula that simply adds the percentage in the same row column E to the next positive percentage above it in same the column as the formula. This would be easier since the next positive percentage can be several rows above.

Thank you and please let me know any farther clarification is needed.

[bebo021999]

There are several rows with negative %, but manual input in F,G,H. (row 7,8,14,19)
Assum all negative % would be ignored, try in F6:

Please Login or Register  to view this content.

Drag down and accross.

[lar9149]

There are several rows with negative %, but manual input in F,G,H. (row 7,8,14,19)
Assum all negative % would be ignored, try in F6:

Please Login or Register  to view this content.

Drag down and accross.

Thank you for the help again bebo

I tested the formula and it works for the said comparison. But I wanted the formula to be adjustable. For example, I included another copy and attach it.

Looking at the red, I manually put in the 0.044 on row 20, in my actual work, sometimes I will do that and override the formula for various reasons. In green under row 23 I put what the answer should be..but the formula doesn't account for that.

Is there a way for modify the formula so it would still work in this situation?

[bebo021999]

in my actual work, sometimes I will do that and override the formula for various reasons.

Instead of overriding the formula, a helper column help to to define override ("Y") or not (blank)

Then in G6:

=IF(AND($E6<0,$D6<>"Y"),"",G$5+SUMIF($E$6:$E6,">0",$E$6:$E6))