Countif for an EXACT name

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.

Find more posts tagged with

Accepted answers

All comments

KPH

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 😉

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.