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

Sorry, i fail to understand your mean, Could you be more specific more
!
May you do it in Sheet, in oder to me clear well.

It's very neccessary for me, pls pls help me

thank you.


--
vumian
------------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
View this thread: http://www.excelforum.com/showthread...hreadid=562520

Vumian,

email me the workbook and I will return it to you with the formula.
Email at:
XX

remove the XXX

Kostis