Hi all,

First time of the forum, so I imagine this has been answered already...
I'm trying to get a number count from multiple criterias and I'm using the following COUNTIFS formula

=COUNTIFS('[Encounter_Design.xlsx]Low 1'!$G:$G, "NCL", '[Encounter_Design.xlsx]Low 1'!$AP:$AZ, "yes")

I am pulling the information from another excel doc.

However when I run this formula I get a #VALUE! outcome. I don't think it's anything to do with the fact I'm pulling the info from another doc as when I run a similar formula using COUNTIF it works fine.

Basically I only want to get a count if G:G is NCL and AP:AZ is yes

Thanks