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.
Bookmarks