Using VLOOKUP to calculate the sum of matching values in an array?

I have a vast array of values split by Year and then sub-split by Type.

For example...

2005
Type 1 500
Type 2 250
Type 3 200

2006
Type 1 475
Type 2 400
Type 3 300

2007
Type 1 800
Type 2 700
Type 3 950

What I would like to do is, rather than =SUM(A1+A6+A11 etc etc) is to use VLOOKUP to calculate the grand total of each Type. Is there a way to incorporate the SUM function into a VLOOKUP formula?

Thanks

Assuming you're not filtering on basis of Year also then just use a SUMIF:

=SUMIF(A:A,"Type 1",B:B)