Need to Count number of unique rows for desired value

Hello,

I'm working on a spreadsheet and I have run into an issue that I have not been able to get around yet. I searched around the forum but have not found an answer so far. Any help would be appreciated.

The problem is as follows:

I have 3 columns. The first tracks the date, the second the country, and the third the expense that was incurred.


1/1/2013 Canada $45
1/1/2013 Canada $56
1/3/2013 Canada $15
1/3/2013 Uganda $23
1/3/2013 Uganda $25
1/5/2013 Canada $55
1/5/2013 Canada $45


For my purposes the expense column is not important, I just included it here to clarify the purpose of the spreadsheet. For each date there could be no entries, or multiple entries. I need to find out how many individual days exist for a country that I am searching for. So in the example above, the answer would be 3 if I searched for Canada, and 1 if I searched for Uganda.

I have attached a sample spreadsheet. I've been trying to find a solution using match, countifs and similar functions, but I can't come up with a formula that works. Any help would be greatly appreciated.

Peter