One easy way:

Use a Pivot Table. Put the Date in the left hand field, and sum of
Amount in the main field. Right-click the date field, choose Group, and
select Year from the listbox.

An example:

ftp://ftp.mcgimpsey.com/excel/pierre_cowguy_demo.xls

In article .com,
"Pierre" wrote:

I've tried SUMIF, and SUMPRODUCT. . .Trying to total values that
occurred within a given year:

We have a column of historical costs, and a corresponding item purchase
date.
The historical costs to total are in a range such as V5:V2050. (Some
cells may be blank)

The dates those values were purchased are in a range such as Z5:Z2050
(formatted as Jan-00 or Jun-03, etc)

In a group of cells, 1 each for the years 1999 thru 2004 I'd like to
have a total of dollars that were spent for each year, with the values
that were summed located in column V as noted above.

For example:
Col:V Col:Z
55.62 Jan-99
12.50 Feb-04
104.88 Sept-04
0.12 Aug-03

RESULTS
A summary cell for each year would show:
That in 1999 purchases were 55.62
In 2003, purchases were 0.12.
In 2004 purchases were 117.38
Thanks in advance for any ideas to make this happen.

Pierre