Hi everyone,

I'm trying to count the number of rows in which two criteria must be satisfied. I have the follow thus far but I'm getting 0 in the results for everything:

=COUNTIFS('Gov Duty Pres Report 1y'!Q:Q,"Yes",'Gov Duty Pres Report 1y'!AC:AC,"XXX")

Help?