Benign

[CarolBowlesvagov]

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.  

[#2]

@CarolBowlesvagov 

=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.

[#3]

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.