Counting unique clients during a specific period of time with other criteria

I am trying to count the number of unique clients who received services from my agency during a specific period of time and further describe them by other criteria such as codes. I like "countifs" and am not an Excel guru.

In my spread sheet:

On the tab marked "DATA":

Column A has a code
Column B contains my client names
Column C is the date of service

On the tab marked "FY Summary" I want to see a count of unique customers by code who received services in a particular fiscal year.

My results would tell me that I had "2 CUW" clients in FY 1 or "10 CDBG" clients in FY 3 etc...

Ideally, I would like to be able to add other criteria based on other columns

I am hoping it will look something like this:

=countifs(B:B,"MAGIC UNIQUE TEXT VALUE FUNCTION",A:A,"CODE",C:C,">=07/01/09",e:e,"<=06/30/10")

Sadly, I don't think it will.

Thanks!!!