Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •