+ Reply to Thread
Results 1 to 2 of 2

SUM with delimiters parameters

  1. #1
    Registered User
    Join Date
    12-03-2020
    Location
    Brazik
    MS-Off Ver
    2013
    Posts
    1

    SUM with delimiters parameters

    I have a sequence of numbers and need add them. The problem is: the sum must be reset when an empty cell is found

    Ex: 123 45 6789

    1+2+3 = 6

    4+5 = 9

    6+7+8+9 = 30
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: SUM with delimiters parameters

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help 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. [SOLVED] Delimiters
    By Bschutz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-06-2019, 05:52 AM
  2. [SOLVED] Fixing delimiters
    By SlipEternal in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-28-2018, 04:34 PM
  3. [SOLVED] Extract string between delimiters
    By Apexeon in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-27-2015, 06:23 PM
  4. vlookup with delimiters
    By karthik013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2014, 11:28 AM
  5. [SOLVED] Extracting a Substring Between Second and Third Delimiters
    By MrGadget6977 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2013, 05:54 PM
  6. Referencing Delimiters
    By Impartial Derivative in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2011, 12:07 AM
  7. concatenating w/ delimiters
    By goji in forum Excel General
    Replies: 3
    Last Post: 09-21-2009, 02:34 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