I have six sheets in a single spreadsheet file. I want to make a seventh sheet that acts as a summary for the other six. Each sheet has two columns that I'm interested in: a date and a dollar value. My goal is to sum the dollar values of all sheets for each month. Ex: Code: [B]Sheet1[/B] 2009-11-24 $100 2009-10-18 $250 2009-10-02 $42 [B]Sheet2[/B] 2009-11-28 $400 2009-11-03 $50 2009-10-05 $316 [B]Sheet3[/B] 2009-12-03 $25 2009-11-04 $25 2009-10-02 $25 and the result would be Code: [B]Summary[/B] 2009-12 $525 2009-11 $325 2009-10 $373 Each sheet has one row per month, but sometimes the dates don't exactly match exactly the month that the date is meant to represent, so I have to round the dates to find the 'correct' month. I've already done that, so on the Summary sheet, I have the Sheet1 dates corrected to 2009-12-01, 2009-11-01, and 2009-10-01. But how do I sum the values from each sheet when the row number for a month in one sheet may not be the same as the row number for that month in another sheet?