CountIFs to count multiple items in same column
I want to count the instances of both "Complete" and "Not Applicable" in the same column. I got it to work with just "Complete" then divide by the total rows to make a percentage using this formula:
=COUNTIF(Status:Status, "Complete") / COUNT(Status:Status)
But when I add the other variable the formula does not work, I have tried
=COUNTIFS([Status]:[Status], "Complete", [Status]:[Status], βNot Applicableβ) / COUNT(Status:Status)
and this
=COUNTIFS([Status]:[Status], "Complete" & βNot Applicableβ) / COUNT(Status:Status)
Best Answer
-
=COUNTIF(Status:Status, OR(@cell = "Complete", @cell = "Not Applicable")) / COUNT(Status:Status)
Answers
-
=COUNTIF(Status:Status, OR(@cell = "Complete", @cell = "Not Applicable")) / COUNT(Status:Status)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!