Count Unique Words During Time Period

Brass Contributor

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 Replies
best response confirmed by BlueMoose (Brass Contributor)



This returns the intended result in my sheet.


Perfect. Thanks so much!