Count Unique Words During Time Period

[BlueMoose]

I am trying to count all instances of the words "COMPLETE" or "CLOSED" in column G; but, I only want to count them when column A has a specific date and column Q has a specific name.  The date in cell AB1 needs to match column A and the person's name in AF2 needs to match what's in column Q, and then give me what's in column G.  I've been trying COUNTIFS, but don't seem to be able to get it quite right.

[#2 · Accepted solution]

@BlueMoose 

=SUMPRODUCT(COUNTIFS(G2:G21,{"COMPLETE","CLOSED"},A2:A21,AB2,Q2:Q21,AF2))

This returns the intended result in my sheet.

 

[#3]

Perfect. Thanks so much!