Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » how do you write a formula based on cell varaibles

how do you write a formula based on cell varaibles

Previous | Next
Latest post Mon, Feb 8 2010 7:52 AM by raymondsmart. 2 replies.

  • Tue, Nov 10 2009 7:49 AM

    how do you write a formula based on cell varaibles

    Reply |Contact

    Hiya,

     

    Cell A1 = 52010

    Cell A2 = Euro

    Cell A3 = United Kingdom

     

    i need to have the following formula in cell A4 =sum('U-52010-E'!A1:A100)

    Cells A1 to A3 change automatically how can i make sure that the formula in A4 changes to calculate accordingly? I have tried this but it doesnt seems to work

    =left(A3,1)&-A1&-&left(A2,1)&'!A1:A100

    any directions?

     

     
    • Post Points: 21

  • Tue, Nov 10 2009 7:52 AM In reply to

    Re: how do you write a formula based on cell varaibles

    Reply |Contact |Mark as Not Answer

    Try

     

    =SUM(INDIRECT("'"&LEFT(A3,1)&"-"&A1&"-"&LEFT(A2,1)&"'!A1:A100"))

    Regards

    Bob

    • Post Points: 21

  • Mon, Feb 8 2010 7:52 AM In reply to

    Re: how do you write a formula based on cell varaibles

    Reply |Contact |Mark as Answer

    Thank you Bob 

     

    Worked a charm
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.