What I'm trying to accomplish is counting how many numbers from column A (starting at A2 and going down) it takes until it adds up to the number in B1. Twist of difficulty is I want a fraction.. So this would result in 3.5. 1+4+3+(half of 2). If A5 was = 3, answer would be 3.3.
<tbody>
</tbody>
A | B | |
1 | 9 | |
2 | 1 | |
3 | 4 | |
4 | 3 | |
5 | 2 | |
6 | 7 | |
7 | 8 | |
8 | 5 | |
9 | 4 |
<tbody>
</tbody>