Can I get some help with this SUMIFS Formula?

[Peter h]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Red
[/TD]
[TD]5
[/TD]
[TD]Red
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Yellow
[/TD]
[TD]3
[/TD]
[TD]Yellow
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Blue
[/TD]
[TD]7
[/TD]
[TD]Red
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Blue
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Red
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Blue
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to get this SUMIFS formula to work, but I can't seem to figure it out. I'd love a bit of guidance. Thanks.

The table shows the results I'm trying to achieve. Here's what I tried, but doesn't work:

=SUMIFS($D$1:$D$6,$C:$C,A1)

Edit: The formula would be in column "B" and dragged down for each item in column "A".

 

[Peter h]

Problem solved. Used =SUMIF($C:$C,A1,$D:$D) and it did what I was looking for.

 

[steve the fish]

The reason your first one failed is the sum range and the criteria range(s) need to be the same length. D1:D6 and C:C are not the same length in terms of number of cells.

 

[Aladin Akyurek]

While SUMIFS would return #VALUE ! when the ranges it reference are not equally sized, the old SUMIF goes ahead and calculates what it can.

 

[Peter h]

The reason your first one failed is the sum range and the criteria range(s) need to be the same length. D1:D6 and C:C are not the same length in terms of number of cells.

Ahhh... Thanks for the explanation. Good to know for the future.