SOLVED

COUNTFS/COUNTIF not working with cells that have multiple values

Copper Contributor
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.
3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
Use wild card character * before and after the criteria like this and you will get the desired count...

=COUNTIF(E4:E200,"*Income*")
THANK YOU! That worked! You’ve saved me another night of sleep lost. :)

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.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution
Use wild card character * before and after the criteria like this and you will get the desired count...

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

View solution in original post