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.

On Nov 16, 3:59*pm, wx4usa <wx4...@gmail.com> wrote:
> 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.

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))

On Nov 16, 3:59*pm, wx4usa <wx4...@gmail.com> wrote:
> 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.

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.

On Nov 17, 11:39*am, wx4usa <wx4...@gmail.com> wrote:
> On Nov 16, 3:59*pm, wx4usa <wx4...@gmail.com> wrote:
>
> > 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.
>
> 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.

sorry, C12, not C4