Adding values within date range

Hi,

I have a table which diplays dates in the first column, then values corresponding to the dates in the third colum. It looks like this:

12/23/2005 Bread $3.25
12/26/2005 Milk $2.50
01/22/2006 Jam $4.00

What I'd like to do is to add the totals of the values listed in the third column according to the dates. For example, the formula should only add money spent within the year 2005.

How can I do this?

Thanks!

Hi robotfighter:

=SUMPRODUCT(--(YEAR($A$1:$A$20)=2005),($C$1:$C$20))

Matt

Thanks. Unfortunately, I was just informed that the values that need to be summed are actually within a specific date range (e.g., between 10/28/1998 and 4/12/1999). Is this possible?

Have you tried a pivot table. This approach is much more flexible for this type of thing

http://www.cpearson.com/excel/pivots.htm

Matt

I have spent the last 30 mins trying to work this out using array formulas, but can't get it to work. I suggest you do this in a couple of steps. Create a new column that creates returns the value to add if the condition is met, or 0 if it is not met.

something like =IF(AND(A1>DATE(2005,12,22),A1<DATE(2005,12,28)),C1,0)

Then simply sum this column

Matt