One way ..

Assume the sample data is in Sheet1, cols A to C
data from row2 down
(Col A = Bank, col B = Loan, col C = Repay Date)

In Sheet2
------------
Col headers in A1:D1 a Bank, Total Loan, # of Loans, Earliest Repay Date
In A2: A5 are listed: Bank A, Bank B, Bank C and Bank D

Put in:

B2: =SUMIF(Sheet1!A:A,A2,Sheet1!B:B)

C2: =SUMPRODUCT((Sheet1!$A$2:$B$25=A2)*(Sheet1!$B$2:$B $25<""))

D2:
=MIN(IF((Sheet1!$A$2:$A$25=A2)*(Sheet1!$C$2:$C$25< ""),Sheet1!$C$2:$C$25))
Array-enter formula in D2 with CTRL+SHIFT+ENTER
Format D2 as date

Select B2:D2, copy down to D5

Adjust the ranges ($A$2:$A$25, $B$2:$B$25, etc) to suit
--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"Gef" wrote in message
...
Hi

As part of a loan management process I need to calculate
the value of loans outstanding with a specific bank, the
number of loans for that bank and the earliest repayment
date.

Sample data:

Bank Loan Repayment Date
Bank A 1000 01/10/2004
Bank A
Bank A 2000 05/10/2004
Bank A
Bank A
Bank A
Bank A
Bank A
Bank B 1200 01/09/2004
Bank B
Bank B 1000 11/09/2004
Bank B
Bank B 500 15/10/2004
Bank B
Bank B
Bank C 1000 20/10/2004
Bank C
Bank C
Bank C
Bank D 12000 19/10/2004
Bank D
Bank D


Bank Total Loans Count of loans Earliest Repayment
Date
Bank A 3000
Bank B 2700
Bank C 1000
Bank D 12000


I can find the value but am struggling with the count and
earliest repayment (by bank). Can anyone help?