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.
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
Help Article Resources
Check out the Formula Handbook template!