drums4monty
12-07-2006, 04:09 AM
Hi all
I am using this code to count the word yes in a range (thanks to dr for the help), how do I make it count the word "yes" or the letter "y". This is to account for the user either typing yes or just y.
=COUNTIF(C9:C25,"yes")
Alan
I am using this code to count the word yes in a range (thanks to dr for the help), how do I make it count the word "yes" or the letter "y". This is to account for the user either typing yes or just y.
=COUNTIF(C9:C25,"yes")
Alan