How to count the total value of unique items

This is almost perfect, but would there be any way to count only the last instead of the first? I could possibly reverse sort the entries but if the formal could account for it that would be better.

But I was able to get the formula and pivot table to work in my sheet. Just for example a project may have had an initial estimated value of $50, but then they come back to us later and they are estimating a higher value. Logically, the most recent estimate would be the most accurate info, and I would prefer to be able to tally that entry.