+ Reply to Thread
Results 1 to 4 of 4

Sum of numbers between dashes?

  1. 01-25-2018, 05:34 PM #1
    Blue11440
    Blue11440 is offline
    Registered User
    Join Date
    11-25-2017
    Location
    New York
    MS-Off Ver
    2016
    Posts
    13

    Sum of numbers between dashes?

    Hello,

    I am looking for some code that will type sum of numbers 1 (they are in column Y) inside 2 dashes/or between 2 dashes "-".
    Results are in column AA (I typed in some results for better understanding, see the document below) ...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-25-2018, 06:16 PM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Sum of numbers between dashes?

    Hello
    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 01-25-2018, 06:30 PM #3
    Blue11440
    Blue11440 is offline
    Registered User
    Join Date
    11-25-2017
    Location
    New York
    MS-Off Ver
    2016
    Posts
    13

    Re: Sum of numbers between dashes?

    Works great, thanks
    Reply With QuoteRegister To Reply
  4. 01-25-2018, 06:44 PM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Sum of numbers between dashes?

    You're welcome. Glad I can offer some help
    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. [SOLVED] Numbers With and Without Dashes
    By mtspaces in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2017, 11:29 AM
  2. Letters Numbers and dashes
    By Parts Peddler in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-02-2014, 03:25 PM
  3. Add Dashes Between Numbers
    By chrisnat in forum Excel General
    Replies: 2
    Last Post: 04-01-2011, 11:06 AM
  4. Converting numbers with dashes
    By Chevy Nick in forum Excel General
    Replies: 3
    Last Post: 11-30-2009, 01:43 PM
  5. Column of numbers that have dashes, how do I get rid of the dashes
    By oddcarout in forum Excel General
    Replies: 1
    Last Post: 05-14-2008, 07:55 PM
  6. Convert phone numbers with dashes in them to just numbers
    By J H in forum Excel General
    Replies: 2
    Last Post: 06-23-2006, 02:00 PM
  7. Convert phone numbers with dashes in them to just numbers
    By J H in forum Excel General
    Replies: 2
    Last Post: 06-22-2006, 09:45 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