Hi guys I hope someone can help me with this.
I have a cell with a number in it (for example let's say cell A1=102
I have a row of numbers (b1:b30) and each cell has a random number in it.
I'm trying to figure out when to "stop counting" once the sum of b1:???>A1
I'm not sure if there's a formula or a conditional formatting that can be used to know when I have surpassed the reference cell A1.
Any help?
help.JPG
Bookmarks