Formula Help - Extract, Match

%3CLINGO-SUB%20id%3D%22lingo-sub-2749411%22%20slang%3D%22en-US%22%3EFormula%20Help%20-%20Extract%2C%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2749411%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20some%20help%20with%20below%3C%2FP%3E%3CP%3EI%20have%20a%20list%20where%20I%20want%20to%20extract%20(from%20column%20B%20into%20cell%20F1%20any%20colours%20that%20appear%20in%20Column%20B%20but%20no%20duplicates)%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20in%20cell%20G1%20i%20want%20this%20to%20total%20all%20the%20'Red'%20with%20the%20total%20value%20from%20column%20c.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20F1%20%3D%20Red%20G1%20%3D58%3C%2FP%3E%3CP%3EF2%20%3D%20Blue%20G2%20%3D%208%3C%2FP%3E%3CP%3EF3%20%3D%20Yell%20G3%20%3D%203%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%26nbsp%3B%20%26nbsp%3B%20B%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20D%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20F%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20G%3C%2FP%3E%3CP%3E1%26nbsp%3B%20%26nbsp%3BRed%26nbsp%3B%20%26nbsp%3B12%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20**%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B**%3C%2FP%3E%3CP%3E2%26nbsp%3B%20%26nbsp%3BBlue%26nbsp%3B%20%26nbsp%3B5%3C%2FP%3E%3CP%3E3%26nbsp%3B%20%26nbsp%3BYell%26nbsp%3B%20%26nbsp%3B%203%3C%2FP%3E%3CP%3E4%26nbsp%3B%20%26nbsp%3BRed%26nbsp%3B%20%26nbsp%3B34%3C%2FP%3E%3CP%3E5%26nbsp%3B%20%26nbsp%3B%20Red%26nbsp%3B%20%26nbsp%3B12%3C%2FP%3E%3CP%3E6%26nbsp%3B%20%26nbsp%3BBlue%26nbsp%3B%20%26nbsp%3B%203%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2749411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2749683%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%20-%20Extract%2C%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2749683%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1155598%22%20target%3D%22_blank%22%3E%40D7d7ono%3C%2FA%3E%26nbsp%3BTry%20this%20in%20G1%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUMIF(%24A%241%3A%24A%246%2CF1%2C%24B%241%3A%24B%246)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Band%20copy%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Replies

@D7d7ono Try this in G1:

 

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

 

 and copy down

@D7d7ono 

On F1 you type the formula

=UNIQUE(B1:B7)

On G1

 

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