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

Christine Lazzaro

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")

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

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

Christine Lazzaro

It WORKED!!!!! Thank you so much! Very appreciative of your helP!