Which formula should I use?

Copper Contributor

Hi all,

Which formula should I use to count the number of suppliers excluding duplicates and using the date filters highlighted in blue?
The result for each example should be the numbers highlighted in yellow. 


Thank you.

2 Replies
best response confirmed by nessatm (Copper Contributor)


Shouldn't the 2nd example return 3? The non-zero suppliers are AAA, BBB and CCC.


In E5:




Copy/paste to H5 and K5


Thank you so much! This is exactly what I need.
Correct, 2nd example result is 3. Sorry, my mistake :)