Hi,
assuming the array table is in sheet named Source. The formula you
should put in B2 is:

=SUMPRODUCT('Source'!$D$2:$D$100*('Source'!$A$2:$A $100=$A2)*('Source'!$C$2:$C$100=B$1))

Copy down and accross as far as necessary.

HTH
Kostis Vezerides