Help Needed With Combining Summing and Filtering

Hello,   Got stuck with a thing and I oculd us some help. It is fairly simple, but I can't get through it.   I have a table that has a list of deals that include info (on row level) like deal amo...