Summing cells in a second cell, based on the color of a third cell

Hello,

Attached is also an example of what I am trying to do as a visual.

Picture.JPG


The customers are categorized based on the risk level associated with them. Each customer is coded red, yellow, or green. Based on the color code of the customer in column A, the total for each customer in column G needs to be added to the color totals in E14, E15, and E16. At the end, I need to get to a total for all green, yellow, and red categorized customers. If I then, for example, change customer 1 from red to yellow in cell A2, cell G2 should now be added to E15 instead of E16.

Thanks in advance for all your help!!!