+ Reply to Thread
Results 1 to 5 of 5

Thread: Sum of rows

  1. 03-19-2010, 08:59 PM #1
    tancuda
    tancuda is offline
    Registered User
    Join Date
    03-19-2010
    Location
    quebec
    MS-Off Ver
    Excel 2003
    Posts
    6

    Sum of rows

    Hi everyone, first question here, hope to get some answers.

    See my attachment for details.

    Thanks
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 03-19-2010, 09:16 PM #2
    Palmetto
    Palmetto is offline
    Forum Guru Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007
    Posts
    3,441

    Re: Sum of rows....

    Using cell D8 in your attachment as the input cell, this formula will do as you ask

    =SUM(OFFSET($A$3,0,0,D8,1))

    Or, non-volatile formula

    =SUM($A$3:INDEX(A3:A11,D8))
    Last edited by Palmetto; 03-19-2010 at 09:21 PM.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
    Reply With Quote Reply With Quote
  3. 03-20-2010, 01:38 PM #3
    tancuda
    tancuda is offline
    Registered User
    Join Date
    03-19-2010
    Location
    quebec
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Sum of rows....

    Thanks alot Palmetto, work great.

    And by the way what do you mean by "non-volatile formula" ?

    Thanks again
    Reply With Quote Reply With Quote
  4. 03-20-2010, 01:44 PM #4
    Palmetto
    Palmetto is offline
    Forum Guru Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007
    Posts
    3,441

    Re: Sum of rows....

    what do you mean by "non-volatile formula" ?
    See this link about Excel volatile functions
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
    Reply With Quote Reply With Quote
  5. 03-21-2010, 09:08 AM #5
    tancuda
    tancuda is offline
    Registered User
    Join Date
    03-19-2010
    Location
    quebec
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Sum of rows

    Thanks again
    Reply With Quote Reply With Quote
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0