Thank you for taking the time to reply. Unfortunately the answer is not what I am looking for.

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'.