This might become my giant excel question post. I'm working with a large spreadsheet and I'm trying to automate it as much as I can. I have sales data as a spreadsheet. Data is by day. I want to summarize it into weeks. A=day B=sales jan-1 $10 jan-2 $10 jan-3 $10 jan-4 $10 jan-5 $10 jan-6 $10 jan-7 $10 I want A to be grouped into the week and B into total sales for the week so it would look like 1/1 - 1/6 = $60 1/7 - 1/13 = $10 Is this possible?