Only count number based on secondary condition

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!

Try this:

=SUMIFS(C:C,B:B,"Exit")

Hope this helps.

Pete

Hi Pete,

Thank you for your response. Unfortunately, that only sums the Exit stage (0) and not the cost of the first stage that I need (300).

=sumproduct(sumif(a2:a9,filter(a2:a9,b2:b9=b6),c2:c9))