Similar to older post

[garcich1]

I have an excel spread sheet with 2 tabs. One tab contains data that I bring over from Access (Cost), the other is where I want to sum my data (Sheet1).

I want Cell Sheet1!D2 to show the sum of all values in Cost!I:I (Time spent stacking product) if :
Sheet1!A1=Cost!A:A, (Weekending date matches?)
Sheet1!B2=Cost!B:B, (Shelf Number matches?)
Sheet1!D1=Cost!H:H, (Item Nomenclature Matches?)
Sheet1!C2=Cost!C:C. (Shelf Number Section matches?)



I'm not sure if I have to use the sumproduct, or sumif formula & how to construct it? Thank you!

[HansV]

Try this:

=SUMPRODUCT((Cost!A1:A60000=Sheet1!A1)*(Cost!B1:B6 0000=Sheet1!B2)*(Cost!C1:C60000=Sheet1!C2)*(Cost!H 1:H60000=Sheet1!D1)*Cost!I1:I60000)

Note that I didn't use entire columns - SUMPRODUCT can't handle them.