lookup double criteria and sum total amt

**sep910** · 01-18-2008, 11:28 PM

Hi, I needs help for this table
it needs to comparing "Requester" and "Reason Description" and the sum "Ttl. Amt" into table in sheet1
TQ for any helps.

**Paul** · 01-19-2008, 12:06 AM

Hi jojo,

On Sheet1, in cell D6 put the following formula:

=SUMPRODUCT(--(Scrap!$J$9:$J$2002=$C5),--(Scrap!$K$9:$K$2002=D$4),(Scrap!$I$9:$I$2002))

After entering it in D6, fill the formula to the right and down as many columns/rows as needed. If your range on 'Scrap' goes below row 2002 you'll need to adjust all the references to 2002 in that formula. (In SUMPRODUCT formulas, all of the ranges must be identical in size, too.)