sum for match criteria
=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
|