+ Reply to Thread
Results 1 to 2 of 2

VBA - Summing column excluding first cell

  1. #1
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    77

    VBA - Summing column excluding first cell

    I have a row of values with a header title I would like to sum.

    I've looked around and see lots of examples but I'm not understanding the use of quotation marks...and probably some other things.
    I understand there is probably a few ways to do this and if someone could give me an explanation of why I would use one over the other that would be great as well.

    So Far I have
    Please Login or Register  to view this content.
    This does work, but I basically had to steal it from someone else, and the examples I've seen don't seem consistent. How are the quotation used and the ampersand?
    Can this be done in one line instead of two?

    Thanks

    Jon

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: VBA - Summing column excluding first cell

    Please Login or Register  to view this content.
    The quotations are around the literal string parts of the formula and the & is used to combine the first string, the variable LastRow and the last string into one continuous string, which when added to the cell via .formula becomes the formula in the cell.
    Last edited by skywriter; 11-21-2017 at 07:50 PM.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing 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: 5
    Last Post: 02-20-2017, 04:09 PM
  2. database: Copy data from range excluding blanks plus one cell on another column
    By danwoltrs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2016, 10:24 AM
  3. [SOLVED] Summing row of values greater than Zero, excluding minimum
    By jdstuffel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2013, 11:38 AM
  4. Replies: 10
    Last Post: 08-30-2010, 10:22 AM
  5. [SOLVED] Summing part of a string excluding cells
    By soph in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2006, 09:10 PM
  6. [SOLVED] summing part of a string, excluding cells
    By soph in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2006, 08:10 PM
  7. Replies: 3
    Last Post: 04-17-2005, 06:13 PM

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