sum for match criteria

[Neall]

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]

I have a follow up question now

I need to add 2 other variables to your answer of

=SUMIF(A8:A23,">=" & DATE(2007,1,1),L8:L23) - SUMIF(A8:A23,">=" &
DATE(2008,1,1),L8:L23)

Now I need to say count if part numbers = abc

I need to break this up now into 2 different part categories and these 2
part categories have about 6 different part numbers each.

Thanks

 

[bapeltzer]

Now that you've got criteria on multiple fields is when I switch from sumif
or countif to sumproduct. If you want to get the total cost of 'abc' parts
in 2007 (I'll assume the part number is in column B):
=SUMIF(--(year(A8:A23)=2007),--(B8:B23="abc"),D823)

 

[Neall]

Thanks, so this is what I have

=SUMPRODUCT(--(YEAR(A8:A23)=2009),--(B8:B23="D03KHLL"),L8:L23)

But I seem to be missing the end criteria where it gives me the sum of the
criteria met of L8:L23

Any suggestions