Counting unique values with multiple criteria

Hi,

I am looking to count the unique amount of customers who are listed in column C based on the criteria that they purchased the product on the 1/08/2014 and that the product came from Department 3. The output I am looking for in this example would be 3. I can do it for this example but when I have 300 different customers it starts getting tricky and I'm a bit stumped on how to incorporate an array formula into a countifs() function or whether there is an alternative.

Date Department Customer
1/08/2014 3 A
1/08/2014 3 B
1/08/2014 2 C
1/08/2014 3 D
4/08/2014 3 A
5/08/2014 2 A
5/08/2014 3 D

Cheers

Hi,

Welcome to the forum.

You need a helper column for this for identifying the unique customers. Please go through the attached file and see if this is what you are looking for.

Thanks so much for the reply @cbatrody but if then I want to count the unique customers for the 5/08/2014, for department 3 then this wouldn't work for me.

Any ideas?

Appreciate the help!!

You just have to modify the "Date" in F3 and "Department" in G3

@f.bomb

Control+shift+enter, not just enter:

Please Login or Register  to view this content.

where F2 houses a date of interest like 1/08/2014 and G2 a department of interest like 3.

Try this..
Modifying.. Sixth Sense solution...
No Array is required..

Formula:

Please Login or Register  to view this content.

Don't forget to click *