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