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