Sum consecutive cells that meet criteria

[Priya006]

Sum consecutive cells that meet criteria
Please provide the excel formula for the below criteria
excel formula for sum of the Amount values when same price occurs consecutively till the next change of price


Actual

Price Amount
2 100
2 100
4 220
5 280
2 300
2 300

Expected

Price Amount result
2 100 200
2 100 200
4 220 220
5 280 280
2 300 600
2 300 600

 

[Priya006]

The following formula gives me a count of runs:
=SUMIFS($C$10:$C$14,$G$10:$G$14,"="&G10)
confirmed with ctrl+shift+enter.

Amount = C10 to C14
Price= G10 to G14

But the above formula it will sum up amount values for all the price value which is equal to 2

 

[mart37]

	E	F
Change	Result

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]200[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]200[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]220[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]280[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]600[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]600[/TD]

[TD="align: center"]

[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Formeln der Tabelle

Zelle Formel F2 =SUMIF($E$2:$E$8,E2,$B$2:$B$8) E3 =IF(AND(IF(A1=A2,TRUE,A2=A3),IF(A2=A3,TRUE,A3=A4)),E2,E2+1) E2 1 <tbody> </tbody>

<tbody>
</tbody>

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4.8

 

[James006]

@ mart37

In your cell E2 ... why not =IF(ROW()=2,1,IF(A2=A1,E1,E1+1))

 

[mart37]

@James006

Excel blindness