Forum Discussion
COUNTIF not counting unless I specifically type criteria out?
I am trying to use a COUNTIF function to count how many times names appear throughout the worksheet tabs. The COUNTIF function works correctly if I physically type out "Smith" for criteria, but not ...
That's what I assumed but I have tried a few things and if I type =COUNTIF('WEEK 1'!A$4:E$19, "*Smith*"), it is counting correctly. Just not sure why I can't put "*B2*" doesn't output the same? Because I am trying to copy down this formula (with multiple COUNTIF functions added together) down without manually typing a new last name every row.
Detlef_Lewin Thank you so much. This worked like a charm and you saved me so much time. I appreciate it!!!!!