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
--
Neall


"bapeltzer" wrote:

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"),D8:D23)


"Neall" wrote:

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

--
Neall


"bapeltzer" wrote:

=sumif(A:A,"=" & date(2007,1,1),D:D) - sumif(A:A,"=" & date(2008,1,1),D:D)
will add up the costs for parts purchased in 2007. The first sumif counts
everything purchased on or after 1/1/07; the second subtracts those purhcased
on or after 1/1/08, so the difference is what was purchased in 2007.

"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