#UNPARSEABLE using COUNTIF and cross-sheet reference in 2 colums

Struggling and would appreciate any guidance………….

I have a huge Master sheet and I have created separate metrics sheet to be utilized in a dashboard. In the Master sheet, there are two separate colums, one for various departments and the other for Approval status of PO's.

In my master sheet when i run the formula below it works fine, yet when I create it in the metric I get UPARSEABLE.

Master Sheet: =COUNTIFS(Department:Department, "MARINE", [Procurement Approval Status]:[Procurement Approval Status], "Approved")

Metric Sheet: =COUNTIFS({SOURCEosdept}:{SOURCEosdept},"MARINE", {SOURCEprocurestatus}:{SOURCEprocurestatus}, "Approved")

Find more posts tagged with

Accepted answers

DKazatsky2

Hi @Christine Lazzaro,

I suspect the issue is with the use of ":" in the second formula. Using Department:Department in the first formula is correct because you are referencing a range. The {SOURCEEoddept} is already a range so there is no need to use the ":". Try using the following.

=COUNTIFS({SOURCEosdept},"MARINE", {SOURCEprocurestatus}, "Approved")

Hope this helps,

Dave

All comments

DKazatsky2

Hi @Christine Lazzaro,

=COUNTIFS({SOURCEosdept},"MARINE", {SOURCEprocurestatus}, "Approved")

Hope this helps,

Dave

Christine Lazzaro

It WORKED!!!!! Thank you so much! Very appreciative of your 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.