Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: Total of a row

  1. #21
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Mark,

    Modify the formula a bit:

    =SUM(!$A$1:B1)

    Activate Insert|Name|Define;
    Enter SumLeft in the Names in workbook box;
    Enter the above formula in the Refers to box;
    Click OK.

    Enter in A1:C1 in some sheet, say, 1,2, and 3 respectively.

    Enter in D1: SumLeft

    Aladin

  2. #22
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-22 07:57, Aladin Akyurek wrote:
    Mark,

    Modify the formula a bit:

    =SUM(!$A$1:B1)

    Activate Insert|Name|Define;
    Enter SumLeft in the Names in workbook box;
    Enter the above formula in the Refers to box;
    Click OK.

    Enter in A1:C1 in some sheet, say, 1,2, and 3 respectively.

    Enter in D1: SumLeft

    Aladin
    This is giving me a circular reference. I do what you suggest, including the new formula. When I use your suggested data A1:C1 then "=SumLeft" in D1, I get "Circular D1" in the status bar.

    When I check the SumLeft in Name|Define, the formula is changed to


    =SUM(!$A$1:D1)


    hence the circular reference in D1. I think I've chosen the wrong thread to be interested in. **** my inquisitive mind!

  3. #23
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok, I like this formula...

    I put some numbers (1,2,3,4) in A14:D14. Select E14. Go to insert, names, define, and put

    SumLeft

    and in the refers to:

    =SUM($A14:D14)

    Click Add. Done !

    Now, in E14 put =SumLeft, you should get 10 (As I did... )
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  4. #24
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah, that worked, don't know why I couldn't get it to work before though. (apart from stupidity)

    Doens't this technique destroy the integrity of the spreadsheet though. j/k

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •