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