Dynamic Sumif of Sheet1 into Sheet2

[u473]

How do I summarize from Sheet1, Purchase Order Amount, by Project &
Vendor
into Sheet2, with VBA only, not thru a direct Pivot table.
Data is already sorted by Project & Vendor
..
Data Source : Sheet1
Column A : Project Code
Column B : Vendor Name
Column C : Purchase Order #
Column D : Purchase Order Amount
..
How do I use a Dynamic Sumif to achieve this Summary ?
Help appreciated,
..
Celeste

 

[Bob Phillips]

=SUMPRODUCT(--(Sheet1!A2:A2000="project"),--(Sheet1!B2:B2000="vendor"),D22000)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)