Hi everyone I'm new to this site and <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym> 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.
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks for your time.
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.
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
C | D |
Input | Output |
1 | 1 |
2 | 3 |
3 | 2 |
4 | -4 |
-10 | 2 |
1 | |
3 | |
2 | |
-4 | |
2 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks for your time.