Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error.
Formula that I am using is
=COUNTIFS({Primary_Owner}, PC@row, {Priority}, "Medium", {Status}, OR("WIP", "Open"))
I am trying to look for a formula, that counts number of issues that are assigned to a Primary Owner where the priority is “Medium” and Status is either WIP or Open.
Can anyone help on how to achieve this using countifs with OR condition, or is there any other formula which I can use to achieve this results?
Best Answer
-
You need an "@cell" reference for each of the OR arguments.
=COUNTIFS({Primary_Owner}, PC@row, {Priority}, "Medium", {Status}, OR(@cell = "WIP", @cell = "Open"))
Answers
-
You need an "@cell" reference for each of the OR arguments.
=COUNTIFS({Primary_Owner}, PC@row, {Priority}, "Medium", {Status}, OR(@cell = "WIP", @cell = "Open"))
-
@Paul Newcome - Thanks Paul. I did try this earlier but didn't work. But now, i retried it again after your suggestion and it did work. Thanks a lot.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!