COUNTIFS
I keep getting results of 0
I am trying to calculate the number of projects by their status and region (Atlantic and West) so I can than populate the information onto a pie chart on a Dashboard. I think I have been looking at this for too long and too many formulas examples and I am now overlooking something. Below is where I have left off with my formula. (I am referencing from a second sheet when entering this formula)
=COUNTIFS({Region}, "Atlantic, West", {Progress}, "Complete, In Progress, Terminated, Not Started")
Any help will be appreciated! 😀
Answers
-
Hi Robyn,
Happy Monday,
I would suggest a helper column that references the statuses you have listed. I'm assuming that you want to count all rows that have each status "Complete, In Progress, Terminated, Not Started".
Add a helper check box column that has a this formula = (IF(OR(Contains("Complete", {Progress}), contains("In Progress", {Progress}), contains("Terminated", {Progress}), contains("Not Started", {Progress})), 1, 0)
Once you have this column then you can run a countif formula to count the number of checks.
Hope this helps,
Best
Brad
MVP OPS
best,
Brad
www.MVPOPS.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!