Value of Most Recant Order

[*shudder*]

Hi Guys,

I am trying to work out a formula for the value of the most recent customer order.

My initial though was to use SUMPRODUCT, however after looking myself I can't work out how to apply a condition to only sum the most recent date.

Example of data and expected results as follows:

Customer	Date	Product	Value
A	01/01/2023	Apples	100
B	01/01/2023	Pears	50
A	01/02/2023	Apples	100
A	01/02/2023	Oranges	75
C	01/03/2023	Oranges	20
C	01/03/2023	Apples	100
C	01/03/2023	Pears	200

A = 175
B = 50
C = 320

Thanks in advance.

 

[FormR]

Thanks Fluff, that works

Excel it isn't returning any values.

Hi, the surprising part is that the suggestion from post #2 returned "nothing" rather than a #NAME? error.