Forum Discussion
Benign
Why can excel not see the word benign? =COUNTIF(A1:H20,"benign") results with 0 and =COUNTIF(A1:H20,"be*")results with 2, the correct count.
=COUNTIF(A1:H20,"benign")Maybe there is "benign " (with a space in the end like in cell E14 in the spreadsheet) instead of "benign" in range A1:H10.
Putting an * after Benign allowed it to count both. Thank you. I had copied and pasted so I was sure the spelling wasn't the issue, but I didn't think about spaces.
