+ Reply to Thread
Results 1 to 5 of 5

Adding in Excel

  1. 09-15-2013, 10:27 AM #1
    dtommy79
    dtommy79 is offline
    Registered User
    Join Date
    09-15-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    17

    Adding in Excel

    Hi,

    Please take a look at the screenshot I've attached. I'd like to add the numbers in column G and display it next to the "Total" cell. But i also want the total to automatically update if I add a new row with new numbers.

    excel.png

    How can I do this?

    Thanks
    Reply With QuoteRegister To Reply
  2. 09-15-2013, 10:32 AM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Adding in Excel

    =sum(g31:g40)
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 09-15-2013, 10:44 AM #3
    dtommy79
    dtommy79 is offline
    Registered User
    Join Date
    09-15-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Adding in Excel

    Thanks very much
    Reply With QuoteRegister To Reply
  4. 09-18-2013, 03:51 PM #4
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Adding in Excel

    Welcome to the Forum dtommy79!

    If your question has been answered please mark your thread as "Solved" so that members will know that your problem is solved.

    Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  5. 09-18-2013, 04:13 PM #5
    dtommy79
    dtommy79 is offline
    Registered User
    Join Date
    09-15-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Adding in Excel

    Done, thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding charts to Excel (Excel 2010)
    By Dessesbo in forum Excel General
    Replies: 3
    Last Post: 05-27-2012, 06:34 AM
  2. Adding files to existing Excel dataset, updating Excel data set
    By fdavidwest in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2012, 07:13 PM
  3. Adding Image into a excel cell and adding a hyperlink to the image
    By saravananiyyanar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2011, 04:16 AM
  4. Linking from Excel to Word - adding more rows in Excel
    By friday13th in forum Excel General
    Replies: 0
    Last Post: 04-18-2008, 05:54 AM
  5. [SOLVED] Adding in Excel
    By Ron in forum Excel General
    Replies: 5
    Last Post: 03-15-2006, 08:25 PM

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.6.0 RC 1