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. 08-10-2013, 07:51 PM #3
    paul_pearson
    paul_pearson is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    107
    Rep Power
    14
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
    By excel_learner in forum Excel Help
    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. Fetch Data from multiple sheets based on criteria VBA
    By Raj Kumar in forum Excel Help
    Replies: 7
    Last Post: 03-06-2012, 07:49 AM

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
  •  

Forum Rules