Sum of non-repeating values. Sierra Chart. NO VBA. NO array

[mescalante48]

Hello everyone,

I'm looking for a formula that will allow me to sum the unique values from a column that may contain repeating values.

if a repeated value appears it will be summed just once, and if a zero value appears the previous sum will be carried up until a new unique value appears.
please see the below example for clarity.

this is Sierra Chart, so no arrays functions or VBA are allowed since the program doesn't support those.

Any help is very appreciated

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	0	323
3	0	323
4	-122	323
5	-132	445
6	-44	577
7	-44	577
8	-44	577
9	0	621
10	0	621
11	256	621
12	256	621
13	219	365
14	119	146
15	27	27
16	0	0
17	0	0
Districts

Cell Formulas
Range	Formula
B3:B17	B3	=IF(A2=A3,B2,B2-A2)

 

[mescalante48]

How about

Fluff.xlsm
	A	B
1
2	0	323
3	0	323
4	-122	323
5	-132	445
6	-44	577
7	-44	577
8	-44	577
9	0	621
10	0	621
11	256	621
12	256	621
13	219	365
14	119	146
15	27	27
16	0	0
17	0	0
Districts

Cell Formulas
Range	Formula
B3:B17	B3	=IF(A2=A3,B2,B2-A2)

Thank you for your response, nevertheless, this solution has a circular reference that will render it unusable.
consider column B is not given it is just an example of the expected result.

 

[Fluff]

My formula does not have a circular reference

consider column B is not given it is just an example of the expected result

Which is exactly what my suggestion gives.