Merge sumbycolor and sumif(text) resulting in sum range (Colour + text = sum)

I am desperately looking for help with this.

i have a sheet with a working sumbycolor macro to sum a range if a different range is of a certain colour.

it also has a working sumif formula to sum a range if a different range contains a specific word.

What i am trying to now do is create a cell that contains both.

I have tried using different combinations of sumif sumifs if and sumbycolor formulae with no success

EG

i am wanting a cell to have as its final value the sum of a column of numerical amounts, as long as the rows contain a certain word and are coloured specifically (both separate columns).

See attached image.

Table.png

I require the total of column D for each "name" separated by color red, orange and green.
So that in "name1" box the red cells in D that correlate to "name1" in F are totaled in the red box.

I really hope i havnt over/under explained this.

*edit added worksheet. Example area in yellow, work area in blue.

What yu haven't done.... is attach a sample workbook.

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.