Is it possible to add percentage (%) amounts to a cell when another cell is changed?

[galls125]

Book1.xlsx

Please see attached example worksheet.

Is there a formula or do I need VBA to add the percentage amounts that appear in cells G4-G8 to cell D11 when the word 'COMPLETE' is selected in the corresponding line?

.i.e. / .e.g. when I select (from a drop down list) the word 'COMPLETE' in cell H5 the percentage amount in cell G5 gets added to cell D11.

There may need to be a formula in cell D11 because the value of D11 should change depending on how may cells in H4-H8 being selected as 'COMPLETE'.

IN SUMMATION: I need the percentage amount in G5 to be added to D11 when 'COMPLETED' is selected in H5. I also need the percentage amount in G6 to be added to D11 when 'COMPLETED' is selected in H6, etc - G7 add to D11 when H7 'COMPLETED' and G8 add to D11 when H8 'COMPLETED'.

Your help would be greatly appreciated to resolve this problem. It is by far too complex for my limited knowledge. Thanking you in advance.