Help with COUNTIF Formula

Hello,

I am attempting to get my formula to count a status only when it's in NSP (the operational company/OPCO) with a status of "Lumen Chg Order Complete" and the checkbox for 'Test & Turn Up Scheduled' is checked.

This is what I have attempted in the formula that is returning UNPARSEABLE as a result:

=COUNTIF({OPCO}, "NSP", AND({Order Status} = "Lumen Chg Order Complete"), {Test & Turn Up Scheduled} = "1"))

I am not sure where the error is, or if there would there be a better formula type to use instead of COUNTIF?

Find more posts tagged with

Accepted answers

All comments

Matt Lynn ACT

@PKane this would be a countifs not a countif. Also change your ="1" to just =1. It doesn't need to be in quotes.

It would look SOMETHING like:

=COUNTIFS({OPCO}, "NSP", {Order Status} = "Lumen Chg Order Complete", {Test & Turn Up Scheduled} = 1)

PKane

@Matt Lynn-PCG thanks very much for your willingness to lend a hand!

I tried the formula you'd shared and its returning #INVALID OPERATION

Can you see any issues with the formula? I checked the references and they are all good and the spelling for everything is correct.

Any ideas of what I can try to adjust?

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.