Advanced 'If, Then' formula needed (I think)

[kas05j]

Good Morning,

I'm wondering if anyone can please help me find out a formula to add the dolar amounts in one column if the terms are met in another column. For Example:

Here is example data to illustrate my problem:

Colors Dollar Amount from Selling Colors
Blue $20
Green $15
Green $10
Blue $20
Yellow $35
Blue $10
Red $15

I would like to create a formulas that would would total the amounts of Blue Dollars Sold, Green Dollars Sold, Yellow Dollars sold, etc. Can anyone please assist? It would be greatly appreciated.

Thank you,

[ragulduy]

Hi, you need to use the SUMIF function. for example:
=SUMIF(A1:A100,"Blue",B1:B100)
will sum all the values in B1:B100 if the corresponding value in column A is equal to "Blue"

[AlKey]

In D2

=IFERROR(INDEX($A$2:$A$8,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$8),,),)),"")
and pull formula down

In C2

=SUMIF($A$2:$A$8,D2,$B$2:$B$8)
and pull formula down

	A	B	C	D
1	Color	Value	Sum	Unique Colors
2	Blue	$20	50	Blue
3	Green	$15	25	Green
4	Green	$10	35	Yellow
5	Blue	$20	15	Red
6	Yellow	$35
7	Blue	$10
8	Red	$15

[kas05j]

Ragulduy, the formula worked perfectly. I just have one more question, how would you word the formula if you wanted to do one that had more than one color. I've included an example of what im talking about below (But the example doesnt work )

=SUMIF(A1:A100,"Blue,Yellow",B1:B100)

Thank you!

Also, I have yet to try AlKey's formula, but i will try it now to compare the results.

Thanks again!

[ragulduy]

=SUMIF(A1:A100,"Blue",B1:B100)+SUMIF(A1:A100,"Yellow",B1:B100)

[AlKey]

=SUMIF(A1:A100,"Blue",B1:B100)+SUMIF(A1:A100,"Yellow",B1:B100)

You can actually do like this

=SUM(SUMIF(A1:A100,{"Blue","Yellow"},B1:B100))