+ Reply to Thread
Results 1 to 4 of 4

Automatic Summing up to Different Formula

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    London, England
    MS-Off Ver
    MS Office 10
    Posts
    69

    Automatic Summing up to Different Formula

    Hi there,

    I was wondering if anyone had a solution to this.
    I have attached a working example of the problem and the desired solution in column C.

    I am producing a spreadsheet of accounts and have a number of rows which need to be the sum of previous rows (in that column).

    Instead of manually summing the number of rows I was wondering if it could be done automatically someway to add all the numbers above it until it reaches the last sum?

    Does that make any sense?! The real version is much bigger, and rows can be added and taken away which I didn't want to be missed out...

    Thanks for any help, would be really appreciated.

    Sam
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,631

    Re: Automatic Summing up to Different Formula

    Hi Sam,

    Try this: In C6 write:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and drag down.
    Or its a bit longer, but may be more self-explanatory equivalent:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    08-14-2014
    Location
    London, England
    MS-Off Ver
    MS Office 10
    Posts
    69

    Re: Automatic Summing up to Different Formula

    Thank you very much Kaper
    Sam

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,631

    Re: Automatic Summing up to Different Formula

    I'm glad it worked.
    And thanks for reputation

    If the above takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Replies: 3
    Last Post: 12-30-2014, 10:36 PM
  2. [SOLVED] Help with Summing Duplicates, deleting rows after summing and filling col. for unsummed
    By solidrock1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2014, 09:11 AM
  3. Formula for automatic summing
    By chickieram63 in forum Excel General
    Replies: 2
    Last Post: 04-21-2011, 02:16 PM
  4. Automatic summing using excel functions
    By krishnapunekar in forum Excel General
    Replies: 0
    Last Post: 07-12-2010, 07:21 AM
  5. Summing formula
    By rhani111 in forum Excel General
    Replies: 4
    Last Post: 07-26-2006, 08:55 AM

Tags for this Thread

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