Countif for an EXACT name

Nick Burrus

Hey there I have a countifs I'm working on however I am trying to count the instances of "Apples" only but not when it says "Apples and Bananas" or "Apples and Oranges" I only want it to return when it matches Apples and only apples in a cell.

Any time I try to do that for example:

=COUNTIFS(Status:Status, "Complete", [Task Name]:[Task Name], "Apples")

Any instance of Apples and Bananas also shows in it, when I just need Apples.

KPH

Hi

I think the formula you have should do exactly what you want. I doublechecked with your exact situation and got the count I was expecting.

=COUNTIFS(Status:Status, "Complete", [Task Name]:[Task Name], "Apples")

Maybe there is something else confounding this?

Nick Burrus

https://community.smartsheet.com/discussion/comment/403727#Comment_403727

Hey there! Thank you! How weird, on mine I'm getting a count of 453 versus there only being 58 exactly. Wonder if my version is different.

I'm realastically using something like "Company Apples" and then there's a "Company Apples and Bananas" but any time I search for Company Apples in the countif it adds everything else in it.

KPH

That doesn't sound like a simple formula issue and I cannot replicate it. I go to a lot of trouble to do the opposite of what you want!!! Counting the exact match is easier. Except when it isn't. I have no idea why it isn't for you. Sorry and good luck.

SteyJ

Hi @Nick Burrus, try this

=COUNTIFS(status:status, "Complete", [task name]:[task name], HAS(@cell, "Apples"))

Nick Burrus

https://community.smartsheet.com/discussion/comment/403736#Comment_403736

So I deleted the entire sheet and redid it and it suddenly works. Must've had a bugged sheet or something!

KPH

Glad the formula was OK!

If in doubt turn it off and on again 😉