Sumif to multiple tabs

Discussion in 'Microsoft Excel Worksheet Functions' started by m3lly, Aug 13, 2012.

  1. m3lly

    m3lly

    Joined:
    Aug 10, 2012
    Likes Received:
    0
    Hi

    I have a multiple tabs in a worksheet where I have similar condition just with a different first 8 digit data and numbers.

    Previously this was what I did, link sumif formula to each of these tabs to derive to numbers. Is there a way to link 1 formula to all of these tabs in more time efficient way?

    Tab 1 : 60111110xxxxxxxxx
    Tab 2 : 60111111xxxxxxxxx

    Not sure whether my question above can be understood :) Please help. Tks
     
    m3lly, Aug 13, 2012
    #1
    1. Advertisements

  2. m3lly

    m3lly

    Joined:
    Aug 10, 2012
    Likes Received:
    0
    I guess I better use an example :

    Worksheet A named Sheet 1, have few lines
    Cell A1 : 6011121 Cell B1 : $2
    Cell A2 : 6011122 Cell B2 : $1
    Cell A3 : 6011123 Cell B3 : $4

    Worksheet B named Sheet 2, have few lines
    Cell A1 : 6015121 Cell B1 : $5
    Cell A2 : 6015122 Cell B2 : $1
    Cell A3 : 6015123 Cell B3 : $3

    Now, I have a summary worksheet where I have this :
    6011121 $xx
    6011122 $xx
    6011123 $xx
    6015121 $xx
    6015122 $xx
    6015123 $xx

    Is there a way to link the formula to multiple worksheets in one go instead link the sumif to each worksheet?
     
    m3lly, Aug 13, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Peg

    Using Sumif on multiple tabs

    Peg, Jul 30, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    234
    hgrove
    Jul 30, 2004
  2. Oscar
    Replies:
    2
    Views:
    1,107
    Bob Phillips
    Jan 11, 2005
  3. Guest

    nested sumif or sumif with two criteria

    Guest, Apr 4, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    1,844
    Harlan Grove
    Apr 5, 2005
  4. Guest

    Embedding a Sumif in a sumif

    Guest, Aug 31, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    678
    Guest
    Aug 31, 2005
  5. Guest

    Sumif across workbook tabs

    Guest, Sep 5, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    600
    Roger Govier
    Sep 6, 2006
  6. Guest

    Can i set up tabs within tabs on Excel?

    Guest, Oct 30, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    10,177
    Roger Govier
    Oct 30, 2006
  7. Guest

    Sumif for multiple tabs

    Guest, Nov 17, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    191
    Roger Govier
    Nov 17, 2006
  8. Guest

    sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"

    Guest, Jun 12, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    9
    Views:
    869
    Bob Phillips
    Jun 12, 2007
Loading...