#INVALID OPERATION

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

Find more posts tagged with

Accepted answers

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]#

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.