+ Reply to Thread
Results 1 to 2 of 2

Delete sums that add to 0 inside a bigger summatory

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    Luxembourg
    MS-Off Ver
    2010
    Posts
    1

    Delete sums that add to 0 inside a bigger summatory

    Hi everyone I'm new to this site and vba in general and I would very much appreciate help since I'm kinda stuck right now...

    In the C column I got a list of numbers and their sum in a bottom yellow cell (in this pic red value). This numbers inside this big summatory sometimes add to 0 (like C2:C6 in the pic orange values)

    What I would like to have is a simplified version of column C in colum D where the numbers of the summatory that add to 0 inside the big sum are removed.

    Basically if c2+c3=0 remove them, otherwise add c3, if c1+c2+c3=0 remove themm otherwise add c4... and so on..

    I'm sorry if I didn't sound clear this a pic of what i mean.

    C D
    Input Output
    1 1
    2 3
    3 2
    4 -4
    -10 2
    1
    3
    2
    -4
    2


    Thanks for your time.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,677

    Re: Delete sums that add to 0 inside a bigger summatory

    Cross-posted at http://www.mrexcel.com/forum/excel-q...ml#post4227406
    Entia non sunt multiplicanda sine necessitate

+ 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. Delete data inside a cell in between two signs
    By sfraneta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2014, 06:14 PM
  2. Replies: 2
    Last Post: 07-29-2013, 05:06 PM
  3. Delete rows where value is bigger then 35
    By keis386 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2011, 01:31 PM
  4. Sort Column, Delete Rows, Delete Column, Move Molumn, more inside?
    By motown in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2008, 09:44 AM
  5. Delete Row when value inside cell is less than 0
    By bm4466 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2006, 01:04 PM
  6. Replies: 2
    Last Post: 03-14-2006, 02:04 AM
  7. [SOLVED] Workbook Bigger and Bigger
    By Ye Yint Win in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2005, 09:05 AM

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