+ Reply to Thread
Results 1 to 7 of 7

Adding new row and automatically calculating the total amount at the bottom

  1. #1
    Registered User
    Join Date
    03-01-2021
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    4

    Adding new row and automatically calculating the total amount at the bottom

    Hello there,

    Is there a way I could add a new row at the bottom of the table (just before the total sum), key in the new data and the final total will be automatically calculated? Currently I need to add a new row manually, then I copy and paste the previous row and I paste in the new row, delete all the data, and key in the amount. But I notice the total sum at the bottom is not being automatically calculated. I need to reformat the formula to add the calculations of the new row.

    Would really appreciate anyone's help on this.

    Thank you

    Undeclared cross post here:

    https://www.mrexcel.com/board/thread...ottom.1163323/
    Attached Images Attached Images
    Last edited by Glenn Kennedy; 03-01-2021 at 12:37 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,495

    Re: Adding new row and automatically calculating the total amount at the bottom

    Please post a sample workbook. See the yellow banner at the top of the page.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-01-2021
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    4

    Re: Adding new row and automatically calculating the total amount at the bottom

    I have attached the file.

    Thank you
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,495

    Re: Adding new row and automatically calculating the total amount at the bottom

    Try:

    H16:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copied across
    and
    J17:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-01-2021
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    4

    Re: Adding new row and automatically calculating the total amount at the bottom

    Thank you it is working fine now

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Adding new row and automatically calculating the total amount at the bottom

    Welcome (back) to the forum.

    Thanks for your question. However, we have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

    But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

    Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

    1) if you have cross-posted, and

    2) the URL of the cross posts.

    That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

    (Note: since you are new here, on THIS occasion I have done it for you.)
    Glenn



  7. #7
    Registered User
    Join Date
    03-01-2021
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    4

    Re: Adding new row and automatically calculating the total amount at the bottom

    Hi Glenn

    Apologies as I wasnt aware of the forum rule #3. It will not happen again in the future.

    Thank you

+ 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. Calculating number of period from total amount allowed
    By jamewoong in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2016, 03:47 PM
  2. Replies: 3
    Last Post: 09-02-2009, 03:22 PM
  3. Adding up total amount earned for the day
    By Bobcalling in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2007, 01:28 AM
  4. Calculating percentage of a changing total amount
    By skratch in forum Excel General
    Replies: 2
    Last Post: 09-26-2006, 04:21 AM
  5. Adding Time:a pivot table to add the total amount of each
    By Wesley Accellent in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-01-2005, 08:10 PM
  6. Calculating total amount of sales for each salesman
    By Exedate in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2005, 05:05 PM
  7. [SOLVED] how do I set up a total amount automatically in excel
    By sue in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-23-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1