Sumif to multiple tabs

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

  1. m3lly

    m3lly

    Joined:
    Aug 10, 2012
    Messages:
    2
    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
    Messages:
    2
    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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Peg

    Using Sumif on multiple tabs

    Peg, Jul 30, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    190
    hgrove
    Jul 30, 2004
  2. Oscar
    Replies:
    2
    Views:
    767
    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,263
    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:
    435
    Guest
    Aug 31, 2005
  5. Guest

    Sumif for multiple tabs

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

Share This Page