Forum Discussion
ash-701
Jul 28, 2021Copper Contributor
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.
=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
- Subodh_Tiwari_sktneerSilver ContributorUse wild card character * before and after the criteria like this and you will get the desired count...
=COUNTIF(E4:E200,"*Income*")- ash-701Copper ContributorTHANK YOU! That worked! You’ve saved me another night of sleep lost. 🙂
- Subodh_Tiwari_sktneerSilver 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.