Issue using COUNTIF function with OR condition where OR is reference to different sheet

Komal Lakshminarasimha

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?

Paul Newcome

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

You need an "@cell" reference for each of the OR arguments.

=COUNTIFS({Primary_Owner}, PC@row, {Priority}, "Medium", {Status}, OR(@cell = "WIP", @cell = "Open"))

Komal Lakshminarasimha

@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.

Paul Newcome

Happy to help. 👍️