COUNTIF Text Cell

Hi All,

I am struggling with this formula to count based on a text field search then qualifying with status drop down type. Still getting errors as I know II am missing someything.

=COUNTIFS({Project Oversight Range 6}, ([Triversity Construction]@row), {Project Oversight Range 2}, "To Do") + COUNTIFS({Project Oversight Range 6}, ([Triversity Construction]@row), {Project Oversight Range 2}, "In Progress") + COUNTIFS({Project Oversight Range 6}, ([Triversity Construction]@row), {Project Oversight Range 2}, "Support")

Pointers would be great.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you able to provide more details behind the logic of what you are wanting to accomplish?

Genevieve P.

Hi @Mike Buckiewicz

To add to Paul's request, could you also identify what type of error you are receiving, and what type of columns each of your ranges/references are?

Thanks!

Genevieve

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.