Excel References Help

Discussion in 'OT Technology' started by weezyfbaby, Nov 7, 2007.

  1. weezyfbaby

    weezyfbaby New Member

    Joined:
    Oct 12, 2006
    Messages:
    12,204
    Likes Received:
    0
    Location:
    Philly
    I am using excel to sumif different values from different sheets but I want to make the formula so I can get it from the sheet I want based on a value in another cell, for example...

    C2 = Sheet2

    I have a formula that has SUMIF(Sheet2!A3:A50,A4,Sheet2!B3:B50)

    and I am using this with different formulas that I have set up already referencing one sheet, but I want to make it so when I copy and paste this down my sheet that I can have it look at one value in the column and pull from the different worksheet (Sheet3, sheet4, etc.)

    Is there anyway to do this?

    If I am not making sense or there are any questions I'll be waiting here

    Thanks OT!
     
  2. weezyfbaby

    weezyfbaby New Member

    Joined:
    Oct 12, 2006
    Messages:
    12,204
    Likes Received:
    0
    Location:
    Philly
    got it nevermind
     

Share This Page