Forum Discussion
BlueMoose
Jun 15, 2023Copper Contributor
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 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.
=SUMPRODUCT(COUNTIFS(G2:G21,{"COMPLETE","CLOSED"},A2:A21,AB2,Q2:Q21,AF2))
This returns the intended result in my sheet.
2 Replies
Sort By
- OliverScheurichGold Contributor
=SUMPRODUCT(COUNTIFS(G2:G21,{"COMPLETE","CLOSED"},A2:A21,AB2,Q2:Q21,AF2))
This returns the intended result in my sheet.
- BlueMooseCopper ContributorPerfect. Thanks so much!