Sum up values from a column based on multiple criteria from different columns

Hi friends,

I'm stuck up to generate a formula for a set of data, I'm partially satisfied with the way I have formulated the logic but it's not giving me a correct result.

To set a context, I have 8 columns with a set of data, I wanted 3 outputs- Output 1, Output 2 and Output 3
Output 1 - output should be the sum of column H and column E where it has "Y"
Output 2 - output should be the sum of column H and column F where it is "Y" and any value that is considered as part of the output in Output 1 should be ignored - basically no duplication on comparison with the earlier column
Output 3 - output should be the sum of column H and column G where it is "Y" and any value that is considered as part of the output in Output 1 and Output 2 should be ignored - basically no duplication on comparison with the earlier columns


I have attached a sample scenario with the data set and required outputs, please help me out with this. I wanted a formula to apply it for a larger set of data.