In H1:Q1, input the year numbers

In G2:Gn, add all vendor ids

In H2, add

=SUMPRODUCT(--($A$2:$A$20=$G2),--(YEAR($B$2:$B$20)=H$1),$C$2:$C$20)

and copy down and across

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ken Zenachon" wrote in message
ups.com...
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