Forum Discussion
Chasercg
Jan 29, 2019Copper Contributor
Formula Help
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 t...
SergeiBaklan
Jan 30, 2019Diamond Contributor
Instead of number you may use formula in A1 like
=100+COUNTIF(B:B, "Yes")*12