sum total of specific criteria

Hi guys

sorry to bother you, but I have been stuck on this particular formula for the last week, and I don’t seem to be progressing any further, and I am hoping you can help


basically there are 2 columns, one with currency the other opportunity type.

what I am trying to achieve with the formula ,

1) if the opp type = close opportunity , I want it to add all the totals within tcv which equals to “close opportunity” and give me a subtotal



hope this is self explanatory , if you have any questions please contact me