The easiest way would be to use a pivot table. Use the vendor as your
row field, the date as the column field and the Amount as the data
field. Then right click on one of the date headings and choose "Group
and Show Detail" and then "Group". Click on years and make sure no other
selections are made and then Ok.

Otherwise if you wanted to do it with formulas enter the vendor names in
G2 downwards and in H1 - Q1 enter 1998, 1999, 2000 etc.
In H2 enter the formula:
=SUMPRODUCT(($A$2:$A$100=$G2)*(YEAR($B$2:$B$100)=H $1)*$C$2:$C$100)
and adjust the ranges to suit your data (I've used rows 2 to 100).
Then copy down and across as required.

Hope this helps
Rowan

Ken Zenachon wrote:
Hi, everyone...
Building formulas is not yet a strong area of mine.
I'll keep it concise.

The scenario:

Given:
Columns A, B and D, respectively:
Vendor, Date, Amount.

I want to build a table of annual sums as follows:
Columns: G, H-Q, respectively:
Vendor, 1998-2006

Each vendor, then, will be listed once in the Vendor column (G). I
should be able to scan across columns H-Q for each vendor row and see
how much I spent at any given vendor in any given year.

Any working solutions would be greatly appreciated.

Thanks,

KZ