formula that does simple math a specific number of times

This site looks awesome. It's unbelievable that so many people are willing to take time to help others.

Not sure if this is the right forum but I need to write a formula that does simple Math by adding 1 to a cell based on certain criteria then stop once that criteria is met a certain number of times which is denoted in one of my cells.

If F10 is > than 0 then G11 = F11 + 1 if True or = F11 if False
If G10 is > than 0 then H11 = G11 +1 if True or = G11 if False
If H10 is > than 0 then I11 =H11 + 1 if True or = H11 if False
If I10 is > than 0 then J11 = I11 +1 if True or = I11 if False

This Formula continues in a series all the way through W10

Let's say D11 has the numeral 4, I need the above formula to stop adding +1 after the 4th time the formula comes back true:

I believe thsi formual in cells g11:w11 does what you seem to be asking

Please Login or Register  to view this content.

well perhaps you could better describe your spreadsheet and what you are trying to do and where my formula came up short.