How to count the total value of unique items

Including a screenshot below. It's hard to explain without over complicating it, but basically all projects have to go through 3 "levels" of funding, resources, etc. Each time a project is submitted to us, we can approve it, or send it back for feedback. A project can come to us at the same "approval level" multiple times, if either we rejected them the first time, or sometimes even if we approve them but then their values/costs change significantly and they need to be reviewed again. For things that come to us multiple times in the same "Approval Level," I really only care about the most recent entry. 

A project can also come to us multiple times as it moves through each level. So we may have approved it at SL2, and now we are approving it at SL3. If a project is approved 3x but they were in different levels (SL1,SL2,SL3) then I want to count each of those. 

What I typically am providing to leadership weekly is the Total NRB for SL2 Approvals, Total NRB for SL2 Feedback Requested, Total NRB for SL3 Approvals, and Total NRB for SL3 Feedback Requested. Because I don't want to include duplications of values (you can see how that would quickly get out of hand), I am manually removing duplicates and only tallying the most recent entry.

Also my version is on Windows and it's listed as Microsoft Excel for Microsoft 365 MSO.