Summation Of Amount for a date range

[pkpandey]

Hi All

How to get the following output from the attached excel sheet.

Item        Amount

A01         550

A02         905

A03         554

Sum of only yellow colored cells i.e. amount between third max date and max date.

[pkpandey]

Hi Sunny T

This is not the correct data from the expression you have given.