My data looks like so (excerpted, I've got about 600 rows of data or more):

01    2005    106108    200000    0.2
01    2008    106108    150000    0.2
01    2009    106108    390000    0.4
01    2009    106108    5750000    5.8
01    2007    109956    40000    0.0
01    2008    109956    150000    0.2
01    2008    109956    60000    0.1

What I'd like to do is have two subtotals for each PIN (PINs are in column
C).  One subtotal would be the sum of Column E if the year = 2005 to 2009
(including 2005 and 2009, column B).  The other subtotal would be for the sum
of Column E for years >=2010.  

The columns are already sorted ascending by column A, then by column C then
by column B.

What would be the best way of going about this?

Thanks for your help!