Copper Contributor

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 Replies



Maybe there is "benign " (with a space in the end like in cell E14 in the spreadsheet) instead of "benign" in range A1:H10.countif.JPG

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.