+ Reply to Thread
Results 1 to 4 of 4

Define Sum Range

  1. #1
    Registered User
    Join Date
    07-30-2007
    Posts
    61

    Question Define Sum Range

    Hi

    In my spreadsheet I need to add a Sum formula.
    However the Sum range will vary each time the report is run.
    The Sum range always starts in cell M13, but the end range could be R13 or S13 etc.
    Then this Formula needs to be filled down to the last row in the data range.
    So basically I need a way of defining the range to Sum each time.

    I would need to be able to do this in VBA too.

    Can anyone help?

    Thank you all in advance

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Define Sum Range

    Hi,
    you can find a solution for dynamic ranges at this site

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Define Sum Range

    roasty_1
    try..
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Define Sum Range

    ops
    for column m a needs to be
    Please Login or Register  to view this content.

+ Reply to Thread

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