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

I'm sorry... I'm not sure how I would apply this to what I am doing... All cells will be added in individual groups, not only ones that meet a certain criteria.

You could try the following...
create a small table in another worksheet which contains a date in column A and some relevant grouping value in column B.
Add a helper column which in the data sheet which does a vlookup on the date against the values in the other worksheet then you get absolute control of the grouping. Then create a pivot table using tha labels in the helper column to group by.

regards