Calculate number of claims and claims paid out per policy year

Hi,
I need to calculate the amount of claims paid out and number of claims per policy year for each customer. The policy year varies for each customer and typically can go from 15th of March 2010 to 14th of March 2011. There might be several claims per policy year for each customer and I want to find out what this amount is. Please see attached file. Customer 6 shows my dilemma. This customer has 3 claims for policy year 2010: 1 in 2010 and 2 in 2011, but they are all in policy year 2010. I have marked it in yellow.
This is a typical case in an insurance company.

I hope somebody can help me again.

Thanks.

Thanks popipipo and FDibbins, both of your methods gave the same result. However, it's not quite right. The claims need to be linked to the policy year for each customer. Customer 39 shows this problems better. The policy year for this customer is from 1 June to 31 May. All claims within the policy year 1 June 2009 to 31 May 2010 should be summed up as the claims paid out for 2009.

I have updated the file so it shows your calculation and the what the result should be for customer 39.

Thanks again, that works for customer 39, but not the other customers. I need one formula that will work for every customer - a formula I can drag down. There are hundreds of customers and thousands of claims all together.

Not quite. Please see the attached picture to see the correct claims for customer 39.

Will that formula work for each policy year (columns C and D) for every customer or just customer 39?

Thanks kvsrinivasamurthy, that's an impressive formula I don't understand It works for customer 39, but why doesn't it work for customer 5? Why do I need to remove duplicates in columns A,B,C and D? I need those entries.

In the formula replace SUM by MAX.
Pl see the file in my latest post.

Thanks kvsrinivasamurthy, that looks perfect! You have fantastic Excel skills Thanks again!

Thanks for the compliment.