+ Reply to Thread
Results 1 to 8 of 8

SUMIF(s) with changeable conditions?

  1. #1
    Registered User
    Join Date
    05-25-2012
    Location
    Drnis, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    31

    SUMIF(s) with changeable conditions?

    Hello,

    I think i can't explain it better then posting example, what i need is calculation of meters in sheet2 from data in sheet1, if conditions like date, W.O. and Shift are the same. Basically i need formula that will do the same as formula for engineers does, but instead of showing the name i need it to sum meters done.

    Any chance of solving this?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: SUMIF(s) with changeable conditions?

    I can't see your example file.

    Pete

  3. #3
    Registered User
    Join Date
    05-25-2012
    Location
    Drnis, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: SUMIF(s) with changeable conditions?

    bah, forgot to upload it

    Knjiga1.xlsx

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: SUMIF(s) with changeable conditions?

    Hi

    Does this, helps you?

    =SUMPRODUCT((List1!$A$2:$A$29=List2!A2)*(List1!$B$2:$B$29=List2!C2)*(List1!$C$2:$C$29=List2!B2)*(List1!$D$2:$D$29=List2!D2)*(List1!$H$2:$H$29))
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: SUMIF(s) with changeable conditions?

    Or use a Pivot table:
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-25-2012
    Location
    Drnis, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: SUMIF(s) with changeable conditions?

    Thanks guys, i'm still amazed with how fast and useful answers are here. If i could use pivot tables this would be a lot easier but i can't, still what Fotis1991 posted works like a charm.

    Thanks again.

  7. #7
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: SUMIF(s) with changeable conditions?

    You are welcome!

    Pls, mark your Thread, as Solved.

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: SUMIF(s) with changeable conditions?

    Also, you could use SUMIFS for XL2010:

    =SUMIFS(List1!H:H;List1!A:A;A2;List1!C:C;B2;List1!B:B;C2;List1!D:D;D2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1