Hi, i'm trying to do a simple COUNTIF for one column, to see how many of each group exist
I'm trying to pull how many of each group are listed in the column Current Owner, and keep returning a message of #blocked.
=COUNTIFS([Current Owner]:[Current Owner], "PDT", "Team Healy")
Thoughts?
Answers
-
You have one too many criterion for the one column you are referencing, OR you are missing a column reference.
Are PDT and Team Healy within the same Current Owner column? If so, then you could do a =COUNTIF([Current Owner]:[Current Owner], "PDT")+COUNTIF([Current Owner]:[Current Owner],"Team Healy")
If either PDT or Team Healy are in different columns then you will need to add that other column in your COUNTIFS, so it would be =COUNTIFS([Current Owner]:[Current Owner], "PDT",[The other column]:[The other column], "Team Healy")
Does that make sense?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!