Forum Discussion

ash-701's avatar
ash-701
Copper Contributor
Jul 28, 2021
Solved

COUNTFS/COUNTIF not working with cells that have multiple values

I cannot figure out a formula that will work for my needs. I need to total the number of times a specific type of error occurs in a specific range of cells. I can total just fine if I use =COUNTIF(e4:e200,”income”) but if a cell has multiple items selected it will not count it if “Income” is one of the items selected in that cell. I’ve tried the following things that have no worked (I get an error):

=COUNTFS(e4:e200, contains(“income”, @cell)) ->results in #NAME? as the result

=COUNTF(e4:e200, has(@cell,”income”@row))

I cannot for the life of me figure it out and I’ve poured over many posts. I’ve attached screen shots of what I’m looking at.
  • Use wild card character * before and after the criteria like this and you will get the desired count...

    =COUNTIF(E4:E200,"*Income*")

3 Replies

  • Use wild card character * before and after the criteria like this and you will get the desired count...

    =COUNTIF(E4:E200,"*Income*")
    • ash-701's avatar
      ash-701
      Copper Contributor
      THANK YOU! That worked! You’ve saved me another night of sleep lost. 🙂
      • Subodh_Tiwari_sktneer's avatar
        Subodh_Tiwari_sktneer
        Silver Contributor

        You're welcome ash-701! Glad it worked as desired.

         

        Please take a minute to accept the post with the proposed solution as Best Response to mark your question as Solved.