Formula Help - Extract, Match

Question

After some help with belowI have a list where I want to extract (from column B into cell F1 any colours that appear in Column B but no duplicates)&nbsp;Then in cell G1 i want this to total all the 'Red' with the total value from column c.&nbsp;So F1 = Red G1 =58F2 = Blue G2 = 8F3 = Yell G3 = 3&nbsp;&nbsp;A&nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; E&nbsp; &nbsp; &nbsp; F&nbsp; &nbsp; &nbsp; G1&nbsp; &nbsp;Red&nbsp; &nbsp;12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; **&nbsp; &nbsp; &nbsp;**2&nbsp; &nbsp;Blue&nbsp; &nbsp;53&nbsp; &nbsp;Yell&nbsp; &nbsp; 34&nbsp; &nbsp;Red&nbsp; &nbsp;345&nbsp; &nbsp; Red&nbsp; &nbsp;126&nbsp; &nbsp;Blue&nbsp; &nbsp; 3&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Answer

D7d7ono&nbsp;Try this in G1:&nbsp;=SUMIF($A$1:$A$6,F1,$B$1:$B$6)&nbsp;&nbsp;and copy down

juliano-petrukio · Answer

D7d7ono&nbsp;On F1 you type the formula=UNIQUE(B1:B7)On G1&nbsp;=SUMIF($B$1:$B$7,F1,$C$1:$C$7)

Forum Discussion

Formula Help - Extract, Match

2 Replies

Resources