COUNTIF CONTAINS HELP
Hello,
I am trying to get a count of how many Greenwaste projects are completed on the sheet.
Here is my fx: =COUNTIFS([District Site]1:[District Site]219, "Greenwaste", Status1:Status219, ("Completed"))
^^^ is returning a zero right now, it should count at least 3 as completed. Can someone let me know what I am doing wrong? Your help is appreciated very much!
Best Answer
-
Hi @KristiTRUSD
I'm glad you were able to figure it out! Yes, if you type a criteria "in quotes" the formula will only look for an exact match.
You could use CONTAINS if you're looking for any cell that contains a certain value.
You may also want to remove out the Row Numbers from your [Column References] so that it will search your entire sheet as new rows are added:
=COUNTIFS([District Site]:[District Site], "Greenwaste", Status:Status, "Completed")
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
Never mind, I figured it out. I wasn't putting the entire statement I wanted SS to search for.
-
Hi @KristiTRUSD
I'm glad you were able to figure it out! Yes, if you type a criteria "in quotes" the formula will only look for an exact match.
You could use CONTAINS if you're looking for any cell that contains a certain value.
You may also want to remove out the Row Numbers from your [Column References] so that it will search your entire sheet as new rows are added:
=COUNTIFS([District Site]:[District Site], "Greenwaste", Status:Status, "Completed")
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!