+ Reply to Thread
Results 1 to 4 of 4

Adding Totals To Worksheet

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    GA
    MS-Off Ver
    Excel 2016
    Posts
    533

    Adding Totals To Worksheet

    Good morning, I am attempting to add totals for columns D & E - I have this formula, but the second it hits the first code block line it immediately leaves the procedure. I assume it is a syntax error that is amis, but I can't spot it! How should this be altered so that columns D & E get summed?
    Error line
    Please Login or Register  to view this content.
    FUll code
    Please Login or Register  to view this content.

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: Adding Totals To Worksheet

    Please Login or Register  to view this content.
    Equivalent to =SUM(D1:D?), where ? = lastRow.
    Last edited by leelnich; 05-09-2017 at 11:47 AM.

  3. #3
    Forum Contributor
    Join Date
    06-18-2010
    Location
    GA
    MS-Off Ver
    Excel 2016
    Posts
    533

    Re: Adding Totals To Worksheet

    Thank you @leelnich - one to many replacesments when I wanted to totals to move from Column C to Column D!

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    '97, 2016
    Posts
    2,523

    Re: Adding Totals To Worksheet

    You're welcome. If this answers your question, please mark the thread as solved. Thanks! - Lee

+ 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. adding monthly totals
    By allan473 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 03-24-2017, 12:33 AM
  2. Adding a new Totals Column
    By jstadtler in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-04-2014, 03:29 PM
  3. adding totals up
    By penguinJen in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-30-2013, 07:00 PM
  4. Adding totals by name on separate worksheet
    By mike519 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-26-2010, 09:04 PM
  5. Adding Totals in a worksheet
    By josterfeld in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2008, 08:43 AM
  6. Adding category totals
    By Cryptographic_ICE@yahoo.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2006, 06:50 PM
  7. Formula for adding several worksheet totals
    By karatefem in forum Excel General
    Replies: 9
    Last Post: 08-18-2005, 11:05 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