I need a formula that says: If B2 has any text, then add a value of "1" to C2 and enter the total in D2.
why not just the condition that if B2 is not blank
then D2 will have
if you insist on condition that if B2 is text then the fomula in D2 is
Say "Thank you"
Glad we were able to help! Love us? Write us a review! Rate CCM
6146 users have said thank you to us this month