I am wondering if any of you excel genius can help me out with the formula below…..

=SUM((Sheet2!A$4:$A$17475=AM2918)*(Sheet2!B$4:$B$17475=AN2918)*(Sheet2!H$4:$H$17475="Left")*(Sheet2!$E$4:$E$17475>=AR2918)*(Sheet2!$E$4:$E$17475<=AV2918))

The above formula works fine and it calculates the sum of values in an array that match certain criteria. The problem I have is that I am trying to add an extra condition that says “only add the sum of items with the latest date”

Do any of you excel genius’s know how to do this, if the dates were found on Sheet2! $F$4:$F$17475?

The F column contains many varying dates and I am just trying to sum the largest?

Does anybody know how to do this because I have been struggling for quite some time?

Any help massively appreciated,

Cheers