I need it to sum up the partial 2011 data (through yesterday's date) and compare it to the existing 2012 data. I was originally summarizing it via a pivot table using the total lines on the data I sent you. I am trying to avoid changing the formula every day. I was hoping to come up with a way that it either knew what the date was for yesterday, and then summarize everything from the 1st of the month through yesterday's date, for both years (even though for 2011 I have data through the end of the month in my data file.

Thanks!