Using CountIfs but counting duplicates only once

[redsheep79]

I need to count the number of client reviews completed by each team for each month. However, a client may appear multiple times (it will be the same date each time, a client wont ever have 2 different dates) but I only want the client counted once.

Please can you advise on how to use countifs but not counting duplicates for the client ref number or if there's another method.

Thank you.

 

[RoryA]

Once again:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Countifs but ignoring duplicates in 1 column [SOLVED]

I need to count the number of client reviews completed by each team for each month. However, a client may appear multiple times (it will be the same date each time, a client wont ever have 2 different dates) but I only want the client counted once. Please can you advise on how to use countifs...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem. Note: that is two posts so far and both have been cross-posted without links, in spite of warnings. The next time will lead to your posting privileges being removed.

 

[redsheep79]

Once again:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Countifs but ignoring duplicates in 1 column [SOLVED]

I need to count the number of client reviews completed by each team for each month. However, a client may appear multiple times (it will be the same date each time, a client wont ever have 2 different dates) but I only want the client counted once. Please can you advise on how to use countifs...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem. Note: that is two posts so far and both have been cross-posted without links, in spite of warnings. The next time will lead to your posting privileges being removed.

Sorry, I hadn't seen the previous warning and wasn't aware the 2 forums were linked.

 

[redsheep79]

Also posted here: Countifs but ignoring duplicates in 1 column

 

[RoryA]

wasn't aware the 2 forums were linked

They aren't. Please read the rules - it's all explained in there.