Product Name Stage Cost
Product A First 100
Product B First 200
Product C First 300
Product D First 400
Product A Exit 0
Product B Exit 0
Product C Second 400
Product D Second 500

I need a formula to help me find the sum of the cost of products (column C) that have an exit stage (column B) and ignore products that have reached a second stage.

In this example, I'd only be counting the first stage for Product A and Product B since those both have reached exit stages.

Can't figure it out on my own. Thank you in advance!