Count unique records with criteria

Hey everyone,

Here is my situation. I am trying to count the number of unique customer in a set of data but I need to have some criteria involved to filter down. Here is an example of the data I have:

Column A - Customer Number (ex. 1,2,3,4,5,etc.)
Column B - Location (ex. MN,TX,MI,WA,etc.)
Column C - Month (ex. Jan, Feb, Mar,etc.)

The formula I've been using to count the unique values is:

=SUM(IF(FREQUENCY(A:A,A:A)>0,1))

This works fine for the total number of unique customers but I need to know for example the number of unique customers in MN in Jan. Is there a variation to this formula that would solve that or a different formula all together? Any help would be much appreciated. Thanks!

Something like:

Please Login or Register  to view this content.

with fixed ranges (not full columns) - adjust ranges to suit and then confirm with CTRL+SHIFT+ENTER

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER