Spreadsheet: 736688d1623809998-formula-to-add-percentages-from-the-next-positive-percentage-above-the-given-row-stock-short-term-comparison-7
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to add percentages from the next positive percentage above the given row
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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.
2021-06-15 11:15:00 |  |  |  | 1.390390890732007e-05 | 0.004814537883883641 | 0.004129608045853939 | 1.390390890732007e-05 |  |  | 0.004814537883883641 | 0.004129608045853939 | 1.390390890732007e-05 | 4243.47
2021-06-15 11:30:00 |  |  |  | 8.695713649431447e-05 |  |  |  |  |  | 0.004901495020377955 | 0.004216565182348253 | 0.0001008610454016345 | 4243.839 |  |  |  | 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%.
2021-06-15 11:45:00 |  |  |  | -0.0004404031349916071 |  |  |  |  |  | 0.004461091885386348 | 0.003776162047356646 | -0.0003395420895899726 | 4241.97
2021-06-15 12:00:00 |  |  |  | -4.714790533644209e-05 |  |  |  |  |  | 0.004413943980049906 | 0.003729014142020204 | -0.0003866899949264146 | 4241.77 |  |  |  | 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.
2021-06-15 12:15:00 |  |  |  | 0.0005846615917410869 |  |  |  |  |  | 0.004998605571790993 | 0.0005846615917410869 | 0.0001979715968146722 | 4244.25
2021-06-15 12:30:00 |  |  |  | 0.0006055251222241154 |  |  |  |  |  | 0.005604130694015108 | 0.001190186713965202 | 0.0008034967190387876 | 4246.82 |  |  |  | Thank you and please let me know any farther clarification is needed.
2021-06-15 12:45:00 |  |  |  | -0.0005135607348556448 |  |  |  |  |  |  |  |  | 4244.639
2021-06-15 13:00:00 |  |  |  | 0.0001041313525131926 |  |  |  |  |  |  |  |  | 4245.081
2021-06-15 13:15:00 |  |  |  | 1.625410681205253e-05 |  |  |  |  |  |  |  |  | 4245.15
2021-06-15 13:30:00 |  |  |  | -0.0002923336042307545 |  |  |  |  |  |  |  |  | 4243.909
2021-06-15 13:45:00 |  |  |  | 0.0005162693168021537 |  |  |  |  |  |  |  |  | 4246.1
2021-06-15 14:00:00 |  |  |  | 0.0008172205082308537 |  |  |  |  |  |  |  |  | 4249.57
2021-06-15 14:15:00 |  |  |  | -0.0004988740037227268 |  |  |  |  |  |  |  |  | 4247.45
2021-06-15 14:30:00 |  |  |  | 0.0004023590624961937 |  |  |  |  |  |  |  |  | 4249.159
2021-06-15 14:45:00 |  |  |  | -0.000143322478636243 |  |  |  |  |  |  |  |  | 4248.55
2021-06-15 15:00:00 |  |  |  | 0.0004377964246624622 |  |  |  |  |  |  |  |  | 4250.41
2021-06-15 15:15:00 |  |  |  | -0.0005011281264630796 |  |  |  |  |  |  |  |  | 4248.28
2021-06-15 15:30:00 |  |  |  | -0.0003271912397486698 |  |  |  |  |  |  |  |  | 4246.89
2021-06-15 15:45:00 |  |  |  | 0.0002802050441617077 |  |  |  |  |  |  |  |  | 4248.08
2021-06-15 16:00:00 |  |  |  | -0.000275418542023731 |  |  |  |  |  |  |  |  | 4246.91