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!!!

What are the start date and end date for FY1,FY2,FY3,FY4 and F5?

Fiscal Years start on 7/1 and end on 6/30. If I can use countifs, I can easily specify the criteria for FY's like this: ">=07/01/09",e:e,"<=06/30/10". Which is Fiscal Year 2010. It's the counting the unique names that I can't figure out. Thanks!

Thank you both for helping! One question, will these work with blanks cells?

Not a big problem if they don't. I had hoped to set it up to look at the entire column so that when I paste in new data, it would be ready to go.

I am checking both now, again thanks!

Fotis,

I have a question about this part of "(Data!$D$2:$D$132=1)" of this formula: =SUMPRODUCT((Data!$A$2:Data!$A$132="CUW")*(Data!$D$2:$D$132=1)*(Data!$C$2:$C$132>=L2)*(Data!$C$2:$C$132<=L3))

It appears to only count the folks who have a "1" in the helper column beside their name. I need to count unique occurrences of a name in a range, I want to know the number of individuals who received services in a fiscal year. I have been counting it manually and my first try at using your formula returned inaccurate results.

Thanks