Reply to thread

Message: [QUOTE="PCLIVE, post: 3749958"] You're welcome. You might also consider having the date you want to match the month and year to in a cell. Example - Let's say you put a date in cell A1 of the current sheet. That date should include the month and year that you want to pull data for. (1/15/2008 the day (15) is not important as long as it is valid. Now you can change your formula to reference that cell when matching the month and year. This will allow you to change just the date in that cell. Additionally, let's say the other criteria are also predefined in cells. Date = A1 "Quotiation Award" = A2 "Construction" = A3 So now the formula might be: =SUMPRODUCT(--(MONTH([2008.xls]Sheet1!A2:A500)=MONTH(A1)),--(YEAR([2008.xls]Sheet1!A2:A500)=YEAR(A1)),--([2008.xls]Sheet1!D2:D500=A2),--([2008.xls]Sheet1!E2:E500=A3),([2008.xls]Sheet1!F2:F500)) Regards, Paul -- [/QUOTE]