Multiple Criteria
I'm trying to apply COUNTIFS condition with multiple criteria with same column:
Column (assigned to): abcd@xyz.com
Column (stage): is not one of --> blank and approved
Column (product stage): is not one of --> blank and 0
=COUNTIFS({SF PM Data Range 3}, "abcd@xyz.com", {SF PM Data Range 5}, <>"", {SF PM Data Range 4}, "0)
Answers
-
You are missing a close quote on your last criteria ("0). Also, quotes aren't required on quantities and will error out unless the quantity is actually a string.
-
it's still not working...it's showing me 0 found instead of my filter shows 296 raw found
-
Hi @tofani,
It sounds like for your last criteria you want to check if it's not something, however your current formula is checking if it IS 0.
Try this:
=COUNTIFS({SF PM Data Range 3}, "abcd@xyz.com", {SF PM Data Range 5}, <> "", {SF PM Data Range 4}, AND(@cell <> 0, @cell <> ""))
This will see if the {SF PM Data Range 4} column is not 0 AND is not blank.
If this doesn't work, it would be useful to see a screen capture of your source sheet where the data is stored, but please block out any sensitive information.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!