I need help with finding a formula. This is what I am trying to achieve. Let's say I type in the # '100' in A1. I would like for every time I typed 'YES' in B1 (or the B column) '12' would be added to 100. For example, 'YES' in B1 my number in A1 would become '112'. I type in 'YES' in B1 and B2 my total in A1 becomes '124'. Can I get some help with this situation? Thank you.