Index() is better


Try:

=INDEX(MAX(A2:A10),(B2:B10=G11)) Commit with Ctrl+Shift+Enter (not just
enter)

{ } should appear on each side of the formula - these can not be keyboard
entered.

where G11 is your acct Number
A:A Dates; B:B Acct Numbers



"wx4usa" wrote:

Can I use SUMPRODUCT to return the date and amount of last payment if
I provide the account number?

Column A is Date mm/dd/yyyy
Column B is account number (numeric 6 digits)
Column C is type: PMNT, Purchase
Column D is amount, either a + or - based on Mayment or Purchase