Hi all,

I have been trying to sum rows given some conditions but I am unable to.
I would like to sum the Y (negative) value of the past year to the X value of the following year restricting to Count.
My data is the following:
HTML Code:
[CODE]
Count      Year    X     Y
A          2018    2    -3
A          2019    9    -9
B          2016    1    -2
B          2017    0    -4
B          2019    1    -14
C          2017    11    9
C          2019    11    6
D          2016    10    -6
D          2017    1       2
[/CODE]
And I would like to have:
HTML Code:
[CODE]
Count      Year    X     Y
A          2018    2    -3
A          2019    12    -9
B          2016    1    -2
B          2017    2    -4
B          2019    1    -14
C          2017    11    9
C          2019    11    6
D          2016    10    -6
D          2017    7       2
[/CODE]
​​​​​​​Thank you