Date and amount of last payment

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

wx4usa

Can anyone help me with a sumproduct question?
I have on sheet 1 columns with Date, Account, Amount in columns A, B,
C

On sheet 2, in A1 I have an account number field that can be changed.

I need a sumproduct formula to return the date of last payment for
that account and in another cell, return the amount of the last
payment.
 
Can anyone help me with a sumproduct question?
I have on  sheet 1 columns with Date, Account, Amount in columns A, B,
C

On sheet 2, in A1 I have an account number field that can be changed.

I need a sumproduct formula to return the date of last payment for
that account and in another cell, return the amount of the last
payment.
Click to expand...

modify this to suit and enter using ctrl +shift + enter as this is an
array formula
where L2 is your date col L is dates>>
=MAX(IF(($L$2:$L$8=L2)*($M$2:$M$8="Joe"),$O$2:$O$8))
 
Can anyone help me with a sumproduct question?
I have on  sheet 1 columns with Date, Account, Amount in columns A, B,
C

On sheet 2, in A1 I have an account number field that can be changed.

I need a sumproduct formula to return the date of last payment for
that account and in another cell, return the amount of the last
payment.
Click to expand...

Hi Don,

Still not working, If I change C4 to $600, it is returned as the
answer. It is incorrect. $600 is the highest payment for account 4,
but not the most recent.
 
Hi Don,

Still not working, If I change C4 to $600, it is returned as the
answer. It is incorrect. $600 is the highest payment for account 4,
but not the most recent.
Click to expand...

sorry, C12, not C4
 
Back
Top