Lookup Formula that can find multiple values and sum them

[cbc3015]

Hi All,

I have a multi-sheet excel 2013.

I want to use a lookup function that finds all the same types and sums the values. I tried Vlookup, but not all the categories have every type every month and I'd like it to stay static from month to month. I also tried Index, but it wasn't returning the right values.

SHEET 1

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]Quality[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Type A[/TD]
[TD]*Want Sum of total (e.g. 5+7+9)[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Type B[/TD]
[TD]*Want Sum of total (e.g. 6+8+10)[/TD]
[/TR]
</tbody>[/TABLE]

SHEET 2

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Category 1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]Type A[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]Type B[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Category 2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]Type A[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD]Type B[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Category 3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]Type A[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Category 4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD]Type B[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

Is there any formula that would do this?

Thank you so much!!

 

[gaz_chops]

Try
=SUMIF(Sheet2!$C$1:$C$10,A1,Sheet2!$D$1:$D$10)

 

[cbc3015]

Wow Thank you!!! I spent 3 hours trying to figure this out and you solved it within seconds. The help is greatly appreciated!

 

[gaz_chops]

You're welcome.