Subtotals dependent on clumps of years

[Rothman]

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!

 

[Dave F]

I'd use a pivot table.

 

[Herbert Seidenberg]

and here it is:
http://www.freefilehosting.net/download/3ddf1

 

[Herbert Seidenberg]

Do not download the above file.
It has been corrupted.