Forum Discussion
Solved
Count Unique Words During Time Period
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 cel...
=SUMPRODUCT(COUNTIFS(G2:G21,{"COMPLETE","CLOSED"},A2:A21,AB2,Q2:Q21,AF2))This returns the intended result in my sheet.
=SUMPRODUCT(COUNTIFS(G2:G21,{"COMPLETE","CLOSED"},A2:A21,AB2,Q2:Q21,AF2))This returns the intended result in my sheet.
Perfect. Thanks so much!