Whoops you are correct. My apologies. I was focusing on the first formula I requested, which would yield the result based on the date ranges listed on the spread sheet.

Also, in your suggested formula, what does the 15,6, represent? I receive this report weekly, and the rows and columns (range) keeps expanding. I recorded a macro of my weekly formatting and formulas and am curious if this formula can be entered in a way that it is fluid to expansion of ranges. (for instance when I enter a vlookup function, I will start from cell A1, click Ctrl Shift right key, and then click left key twice. This way no mater how many columns get entered, my formula will always look for last cell and go back to the third to last column)

I hope I'm not asking for too much assistance.

Thank you so much!