Help with CountIf Formula
I need a count of # of rows based on data in 2 different columns. All data is on the same reference sheet.
Here is the formula I have written that keeps coming back as unparseable:
=COUNTIF({Global Talent Mobility Intake Range 1}, OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"),AND ({Global Talent Mobility Intake Range 2}, "Operations")))
I receive an accurate count for: COUNTIF({Global Talent Mobility Intake Range 1}, OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"), and I receive an accurate count for: =COUNTIF({Global Talent Mobility Intake Range 2}, "Operations"). I receive an error when I try to combine the 2 together.
What I am trying to count is...if Status is "New", "On Deck", or "Backlog" AND Team is "Operations", show me the total #.
Any suggestions? Thanks!
Best Answer
-
@jpoulo Try the COUNTIFS function
=COUNTIFS([Column7]:[Column7], OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"), [Column8]:[Column8], ="Operations")
... works for me. Just replace column 7 with your external ref Range 1, column8 with your Range 2.
dm
Answers
-
@jpoulo Try the COUNTIFS function
=COUNTIFS([Column7]:[Column7], OR(@cell = "New", @cell = "On Deck", @cell = "Backlog"), [Column8]:[Column8], ="Operations")
... works for me. Just replace column 7 with your external ref Range 1, column8 with your Range 2.
dm
-
@Dale Murphy - Thank you for the help! That worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!