+ Reply to Thread
Results 1 to 4 of 4

Using Cell Value to Construct Range in formyla.

  1. #1
    Registered User
    Join Date
    02-21-2021
    Location
    Toronto
    MS-Off Ver
    365
    Posts
    7

    Using Cell Value to Construct Range in formyla.

    As Example I want Cell C1 to hold SUM of all rows starting from A1 till Ax,
    x is changing and stored in cell B1.
    Cell C1=SUM(A1:Ax) When x=100, cell B1=100,Cell C1=SUM(A1:A100)
    (Basically want to replace 100 with B1 value)

    How to do this is with formula in Excel.

    Thanks.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Using Cell Value to Construct Range in formyla.

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-21-2021
    Location
    Toronto
    MS-Off Ver
    365
    Posts
    7

    Re: Using Cell Value to Construct Range in formyla.

    That Works, Thank You.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Using Cell Value to Construct Range in formyla.

    You're welcome & thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to get cell value based on formula I construct
    By mcleary1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-08-2020, 01:53 PM
  2. [SOLVED] Getting Value of Named Cell After Using User Input to Construct Cell Name
    By Gildor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2019, 04:56 PM
  3. [SOLVED] Using the Changing values of a range to construct a new data array
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-26-2013, 08:06 AM
  4. How do I construct multiple If conditions in a cell?
    By bramfield in forum Excel General
    Replies: 1
    Last Post: 07-21-2010, 04:26 AM
  5. Using a cell contents to construct a formula?
    By pradhan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2010, 09:21 PM
  6. [SOLVED] Construct cell reference for use in formula
    By AG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2005, 11:05 AM
  7. [SOLVED] construct range?
    By Jeff Higgins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2005, 12:06 AM

Tags for this Thread

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