I have a 2007 file which has sales for each day from August to the end of the
year. My 2008 file which is currently used looks into the 2007 file for data.
I am trying to sum the sales from August to the current run date which is
already used in a formula. What would be the easiest way to do this? Thanks
in advance.

Ex:
Sales Run Date
Aug 10 55555 11/14/08
Aug 11 555556
Nov 14 444444
.......... 88888
Dec 14 77777