I have a column of dates that span many years. Each of the dates has a corresponding amount of money that was spent on that day. I need a formula that will take only a certain year (or part of a year) and then sum the amount of money spent only on those days and put that value into one cell.

I have tried sum, sumif, ......and all sorts of formulas.

Any suggestions for this one? Do you need to know more?

Thanks in advance.