Forum Discussion

CarolBowlesvagov's avatar
CarolBowlesvagov
Copper Contributor
Feb 01, 2023

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.  

Excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Feb 01, 2023

    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.

    • CarolBowlesvagov's avatar
      CarolBowlesvagov
      Copper Contributor
      Feb 02, 2023
      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.

Share

Resources