#INVALID OPERATION

Psaul Henry

=COUNTIFS([Project Phase]:[Project Phase], "Readiness", Phase:Phase, "Phase 1", Status:Status, "Complete" / [Project Phase 1 - Readiness]#)

Can anyone please help me solve this problem?

When I have 2 ranges and 2 criterions the formula works, when I increased to 3 ranges and 3 criterions im met with #INVALID OPERATION.

Paul Newcome

You have your closing parenthesis in the wrong place:

=COUNTIFS([Project Phase]:[Project Phase], "Readiness", Phase:Phase, "Phase 1", Status:Status, "Complete") / [Project Phase 1 - Readiness]#

Emily Zeiger

Unless I'm reading your formula wrong - I think you have an extra layer following the 3rd criterion beginning with the /

Psaul Henry

Hi Emily,

The last part of the formula is referencing another summary field '/ [Project Phase 1 - Readiness]#)', again it doesn't cause a problem when there are only 2 ranges and 2 criterions.

Still not sure why adding a third has caused this problem.

Paul Newcome

You have your closing parenthesis in the wrong place:

=COUNTIFS([Project Phase]:[Project Phase], "Readiness", Phase:Phase, "Phase 1", Status:Status, "Complete") / [Project Phase 1 - Readiness]#

Psaul Henry

Thank you Paul.

Paul Newcome

Happy to help. 👍️