The Table will be filled filled
Item LT LH LC
3150169 ? ? ?
3150173 ? ? ?
3150175 ? ? ?
3150171 ? ? ?
3150415 ? ? ?
3160142 ? ? ?

This is a Array Table with multi Criteria
Item Date Criteria Value
3150169 17/07/06 LT 1000
3150173 17/07/06 LH 1500
3150173 18/07/06 LH 2250
3160142 17/07/06 LH 247
3160142 18/07/06 LC 498
3160521 17/07/06 LC 254
3160521 18/07/06 LC 457

- Cells contain ? Will be get col 4 at Array Table
- If Two or multi Item same, The Value will be sum
- Ex: Item: 3150173 has 2 different date, However, Value col must be
sum: 3750


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

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