I have a list of sales data. Column A is a list of dates (workdays). Column
B is the corresponding sales for those days.

I need to write a formula that will give me the sum of prior years sales
from the first of that year to the current date of that year. For instance,
today's date is 7/29/08. I want a formula that will sum the sales between
1/1/07 through 7/29/07. Any help would be appreciated.
--
Don Rountree