A column indicate time and B column is price. I will put D2 Time need to add all price in B2:B10.( less than d2 time)
Example;
Time .........Price
1:27 ....... -0.313
4:15 ....... -0.167
7:58 ....... 0.119
10:13 ...... -0.194
8:39........ 0.306
13:03 ....... 0.314
14:21 ...... 0.326
14:59 ...... 0.808
15:16 .......1.694
D2 time is 10.13, need to add -0.194+0.119+(-0.167)+(-0.313)=??????
Bookmarks