Countif for an EXACT name

Options
Nick Burrus
Nick Burrus ✭✭✭✭✭✭
edited 11/07/23 in Formulas and Functions

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.

Dr. St Nicholas Burrus DHA, PMP

I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!