count on a date range

[aivoryuk]

Hi all

I have 3 columns of dates

column A = date loan was taken
Column B = Date loan is to be repaid
Column C - Date loan was actually repaid.


What I want to do is for all loans that were taken out on 01/02/2011 ( cell A1) I want to count all the loans in column C that were repaid earlier than the date in Column B

What would be the best way to go about this, I have tried sum product but this does not seem to work

 

[Andrew Poulsom]

This worked for me:

=SUMPRODUCT(--(A2:A11=A1),--((C2:C11>B2:B11)))