COUNTIF - FINDING MULTIPLE VALUES IN 2 COLUMNS
Donni Matthew
✭✭✭✭
I am trying to write a formula that will count 2 values in one column & exclude two values in another column. My two columns are: Department & Modified. I want to count the words "Sale" and "Manager" in this multi-select column but only if the Modified column doesn't contain "Furlough" or "Separated".
I tried: =COUNTIFS({VA DEPARTMENT}, FIND ("MANAGER",@CELL)>0, {VA DEPARTMENT}, FIND ("SALE",@CELL)>0, {VA MODIFIED}, @CELL <>"FURLOUGH",{VA MODIFIED}, @CELL <>"SEPARATED")
Suggestions please.
Tags:
Answers
-
Try something like this...
=COUNTIFS({VA DEPARTMENT}, OR(@cell = "Manager", @cell = "Sale"), {VA MODIFIED}, AND(@cell <> "Furlough", @cell <> "Separated"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!