Hello! In column B I have a list of dates from 11/1/09 through 8/28/10. In column C I have various dollars associated with costs accumulated on those dates.
Below this data I have a listed in columns B through M each month of the year and above the actual text, a start and end date for each month.

What I would like to do is do a search on the column of dates, and if the search finds, for example, 2/11/10, I would like to pull the dollar value from column C, and put it in the February cell below. If there are multiple values in February, I would like them to add up to one number for all costs in Feb.

Right now I am trying the AND function and comparing the date in B2 to the start and end dates for the months. The problem is that I have to review hundreds of dates, and feel like with this approach I have to have a formula for each cell with a date in it.

Any thoughts on how I could make this easier??

Thanks!!