Hi,
In a new column let's assume Column E starting in E1 enter 2007 down to 2011
then in F1 enter

=sumproduct(E1=$A$1:$A$1000),$D$1:$D$1000)
Copy the formula down

Change the range to fit your needs, but remember range has to be identical
in both sides of the formula (A and D)

If this helps please click yes, thanks

"Neall" wrote:

I am trying to get a sum of part cost for each year

I have a table with dates that are between 39814 (2007) and 40908 (2011)

this is Column A, in column D are the prices for the parts

So I want to find the sum of all part costs purchased between 39814 and
39813 (2007) then I will do the same for 2008,2009, 2010 etc.

Any suggestions



--
Neall