Results 1 to 4 of 4

Thread: SUM Values From Across Different Sheets Based On Multiple Criteria

  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    12

    SUM Values From Across Different Sheets Based On Multiple Criteria

    I added a new group into Userform and altered the code to suit...that part works

    On main page I have also added 2 new cells (Fast and Slow).Example in Tims sheet if there is WALK AND FAST WALK in "Type" Column then it adds the amounts from the "Amount" column for Walk and Fast Walk and places TOTAL in MAIN!H9 (SLOW) for that date It sees in H6...will change daily

    On main page I have also added 2 new cells (Fast and Slow).Example in Tims sheet if there is run,jog and sprint in "Type" Column then it adds the amounts from the "Amount" column for run,jog and sprint and places TOTAL in MAIN!H10 (FAST) for that date It sees in H6...will change daily

    Thanks

    Paul
    Attached Files Attached Files

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    You can try this in H9

    =SUM(SUMIFS(INDIRECT(H5&"!d4:d100"),INDIRECT(H5&"! b4:b100"),B3,INDIRECT(H5&"!e4:e100"),{"walk","fast walk"}))
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  3. #3
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    12
    Thanks Admin

    That worked but I have changed the sheet tabs to TIM A,GREG B,PETER C as well as the headings in MAIN Sheet (G5,G13,G21)....the formulas have now a REF error...Now that MAIN Sheet (cells G5,G13,G21) have been merged there is an error

    I changed the formula from H5 to G5 but still error....is the merged cell causing the issue?

    Thanks

    Paul
    Attached Files Attached Files

  4. #4
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    it would be

    =SUM(SUMIFS(INDIRECT("'"&G5&"'!d4:d100"),INDIRECT( "'"&G5&"'! b4:b100"),B3,INDIRECT("'"&G5&"'!e4:e100"),{"walk", "fast walk"}))

    And your sheet is ' TIM A', delete the space.

    Also if there is a space in sheet name we need to wrap the sheet name in single quote while using formula INDIRECT.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. Sum values based on multiple criteria
    By Jorrg1 in forum Excel Help
    Replies: 8
    Last Post: 01-07-2013, 03:04 PM
  3. Sum values based on multiple criteria
    By vmath in forum Excel Help
    Replies: 1
    Last Post: 05-07-2012, 08:53 AM
  4. Fetch multiple values based on criteria
    By Lucero in forum Excel Help
    Replies: 8
    Last Post: 04-07-2012, 12:35 PM
  5. Replies: 7
    Last Post: 03-06-2012, 07:49 AM

Posting Permissions

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