Cumulative sum (if values match)

[Median]

I'm trying to have a rolling sum based on the number in a third row (vs just a cumulative sum) as a single formula i.e.

yEw7KaQFRYWHHjjeVQd5aw.png

i.e. row 3 = 2.74, cumulative sum using the values in row 2, for the values 2.74

And basically, this sum resets after each new number.

Is such a formula possible?

Ty
Mdn

[AliGW]

Sorry, I don't understand the maths you are trying to explain.

Which rows are you trying to automate? How do the rows relate to each other?

[Median]

It is a little bit tricky to explain

So row 4 is the cumulative sum of row 2, but the sum resets after each new number in row 3 (when 2.74 changed to 2.76, the sum reset)

qfGU76l8SvedQBvsugFKyQ.png

[AliGW]

Got it! OK - I'll have a proper look now.

[AliGW]

Where did the decimal numbers come from? How does 547 become 547.43???

EDIT: Ignore this!

[AliGW]

In A4 drag copied right:

=SUMIF($A$3:A3,A3,$A$2:A2)

[samba_ravi]

A4=SUMIFS($A2:A2,$A3:A3,A3)
Try this and copy towards right

[Median]

Bril, massively appreciated all

[AliGW]

You're welcome!