Results 1 to 5 of 5

Creating a variable in excel

Threaded View

Alexander_V Creating a variable in excel 10-25-2011, 04:33 AM
Andrew-R Re: Creating a variable in... 10-25-2011, 04:58 AM
Alexander_V Re: Creating a variable in... 10-25-2011, 08:03 AM
Andrew-R Re: Creating a variable in... 10-25-2011, 08:06 AM
Alexander_V Re: Creating a variable in... 10-25-2011, 11:18 AM
  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Norrköping Sweden
    MS-Off Ver
    Excel 2003
    Posts
    13

    Creating a variable in excel

    Hello!
    Quite not sure how to formulate this but my problem is as following:

    Imagine I have the following in an excell sheet

    A B
    12 A2
    12 A6
    1
    1
    2 Sum(value(B1):value(B2))
    2
    1
    1
    1
    43


    I want to be able to in B5 sum any what is written in B1 and B2, so If I change B2 to "A10" it should sum from A2 to A10. So basically I need the values in B1 and B2 to be variables. Hope you understad my question, thankfull for any help.

    Regards Alexander
    Last edited by Alexander_V; 10-25-2011 at 04:38 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1