Formula question when counting 2 values in a restricted drop down values only column

Hi, hope you can help me.
I have this formula
=COUNTIFS({Clients Status Active}, "Active", {Client Grouping}, "Remote Access + Shared Folder – Not Validated")
and i want to add 1 more criteria
{Primary ID}, "Y", "Generic")
I want it to count both the "Y and Generic" in the primary ID column.
I keep getting a incorrect argument error
Best Answer
-
Hey @Peggy
The OR function should help you get what you need.
=COUNTIFS({Clients Status Active}, "Active", {Client Grouping}, "Remote Access + Shared Folder – Not Validated", {Primary ID}, OR(@cell="Y", @cell="Generic"))
Please remember if you have not created your {Primary ID} reference that you will need to manuall insert that through the formula window.
Does this work for you?
Kelly
Answers
-
Hey @Peggy
The OR function should help you get what you need.
=COUNTIFS({Clients Status Active}, "Active", {Client Grouping}, "Remote Access + Shared Folder – Not Validated", {Primary ID}, OR(@cell="Y", @cell="Generic"))
Please remember if you have not created your {Primary ID} reference that you will need to manuall insert that through the formula window.
Does this work for you?
Kelly
-
Thank you Kelly! That worked :-)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!