Help with a formula

Hello All,

Getting an unparseable error for this COUNTIFS formula - hoping someone in the community can help me figure out where I am going wrong.

Formula:

=IF(COUNTIFS({{DC UPS Restudy Status}}, "Restudy Needed", {{Core OpCo}}, "NSP", 1) =0, "", COUNTIFS({{DC UPS Restudy Status}}, "Restudy Needed", {{Core OpCo}}, "NSP", 1))

Snip of the sheet:

Ideally, I want the formula to look at the DC UPS Restudy Status column and count them by OPCO.

Find more posts tagged with

Accepted answers

All comments

Kleerfyre

You don't need the double {{ just make them single ones. And if this formula is being used on the same sheet as the columns you are using in the formula, you should be using [ instead of { .

PKane

@Kleerfyre thanks for your help - I removed one of the sets of { to make it single and it changed to INCORRECT ARGUMENT SET now - which is progress, but I still can't see what the issue is with the formula. :(

Formula updated: =IF(COUNTIFS({DC UPS Restudy Status}, "Restudy Needed", {Core OpCo}, "NSP", 1) = 0, "", COUNTIFS({DC UPS Restudy Status}, "Restudy Needed", {Core OpCo}, "NSP", 1))

I am using the formula in a separate sheet. Thanks for the heads-up on the [ vs the {. I was unaware of that requirement.

Carson Penticuff

COUNTIFS({DC UPS Restudy Status}, "Restudy Needed", {Core OpCo}, "NSP", 1)

What does the 1 at the end of each of these two parts of the formula represent? The syntax of COUNTIFS is COUNTIFS( range1 criterion1 [ range2criterion2... ])

Kleerfyre

Formula updated: =IF(COUNTIFS({DC UPS Restudy Status}, "Restudy Needed", {Core OpCo}, "NSP") = 0, "", COUNTIFS({DC UPS Restudy Status}, "Restudy Needed", {Core OpCo}, "NSP"))

Try that and see if it works.

Kleerfyre

@Carson Penticuff it was because he is trying to combine it with an IF statement too. I noticed that on my second read of his formula. The updated formula I posted should fix the issue.

Sign in to join the conversation!

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.