Formula Help - Extract, Match

[D7d7ono]

After some help with below

I have a list where I want to extract (from column B into cell F1 any colours that appear in Column B but no duplicates) 

Then in cell G1 i want this to total all the 'Red' with the total value from column c.

So F1 = Red G1 =58

F2 = Blue G2 = 8

F3 = Yell G3 = 3

A    B       C      D      E      F      G

1   Red   12                      **     **

2   Blue   5

3   Yell    3

4   Red   34

5    Red   12

6   Blue    3

[#2]

@D7d7ono Try this in G1:

=SUMIF($A$1:$A$6,F1,$B$1:$B$6)

 and copy down

[#3]

@D7d7ono 

On F1 you type the formula

=UNIQUE(B1:B7)

On G1

=SUMIF($B$1:$B$7,F1,$C$1:$C$7)