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!