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

Extending the current set of data, now I have a different assessment number and multiple persons as well

Output 1 - output should be the sum of column H and column A where it is "A1" and column E where it has "Y"
Output 2 - output should be the sum of column H and column A where it is "A1" 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 A where it is "A1" 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
Output 4 - output should be the sum of column H and column A where it is "A2" and column E where it has "Y"
Output 5 - output should be the sum of column H and column A where it is "A2" and column J where it is "Y" and any value that is considered as part of the output in Output 4 should be ignored - basically no duplication on comparison with the earlier column
Output 6 - output should be the sum of column H and column A where it is "A2" and column K where it is "Y" and any value that is considered as part of the output in Output 4 and Output 5 should be ignored - basically no duplication on comparison with the earlier column
Output 7 - output should be the sum of column H and column A where it is "A2" and column L where it is "Y" and any value that is considered as part of the output in Output 4 and Output 5 and Output 6 should be ignored - basically no duplication on comparison with the earlier column

Thanks & regards,
Snehith