Results 1 to 4 of 4

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    13

    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

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
  •