oops
sumproduct((year(Sheet1!$F$3:$F$300)=2007)*(Sheet1 !$F$3:$F$300)=row(a1))*$K$3:$K$300)--
for month
sumproduct((year(Sheet1!$F$3:$F$300)=2007)*(month( Sheet1!$F$3:$F$300)=row(a1))*$K$3:$K$300)--Don GuillettMicrosoft MVP ExcelSalesAid "Don Guillett" wrote in . .. try thissumproduct((year(Sheet1!$F$3:$F$300)=2007)*( Sheet1!$F$3:$F$300)=row(a1))*$K$3:$K$300)--Don GuillettMicrosoft MVP "Looping wrote ... I'll try hardernext time... The first error I got was "The formula you typed in containserrors" After changingsumproduct(year(daterng)=2007)*(month(dat erng)=row(a1))*valuerng)tosumproduct(year(Sheet1! $F$3:$F$300)=2007)*(1(Sheet1!$F$3:$F$300)=row(a1)) *$K$3:$K$300). I got "The formula you typed in contains errors" Doesthis help? "David Biddulph" wrote: And you want us to guess *what* theerror messages were, and you alsowant us to guess what you thought Donmeant and what you changed the formulato? I assume that you are happy toguess at the answer if you want us toguess at the question? [And thisreply isn't just criticising you, but it is to remind all those askingquestions that the experts (and the rest of us!) don't havecrystal ballsto allow us to see what you've got on your screen.] -- DavidBiddulph "Looping through" wrote in ... I did but Igot error messages. I tried to change the formula to what I thought youneant, but again errors. "Don Guillett" wrote: Did you try itfirst? Just copy down 12 for 12 months. The row(a1) changes as youcopy DOWN "Looping wrote in ... Cna youplease explain you formula. I don't follow? Do I copy downto "December" or down to the end of my data range? Thanks "Don Guillett" wrote: how about this copied down =sumproduct(year(daterng)=2007)*(month(daterng)=ro w(a1))*valuerng) -- Don Guillett Microsoft MVP Excel SalesAid Software "Looping wrotein ... I amusing the following the formula to look at all the orders Ihave from 2006. I now want to look at each month individually. how canthisbe done? =SUMPRODUCT((Sheet1!$F$3:$F$300<DATE(2007,1,1)) *Sheet1!$K$3:$K$300)/SUMPRODUCT((Sheet1!$F$3:$F$300<DATE(2007,1,1))*(Sh eet1!$K$3:$K$3000)*Sheet1!$D$3:$D$300) I will also need to do this for each month in2007 as well. But Ido not want to include anythingbefore 1/1/2007. Thanks Peter