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

	A	B
1		Quality
2	Type A	*Want Sum of total (e.g. 5+7+9)
3	Type B	*Want Sum of total (e.g. 6+8+10)

<tbody>
</tbody>

SHEET 2

	A	B	C
1	Category 1
2		Type A	5
3		Type B	6
4	Category 2
5		Type A	7
6		Type B	8
7	Category 3
8		Type A	9
9	Category 4
10		Type B	10

<tbody>
</tbody>

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.