Sum Cumulative that restarts with if there a 0.

[eatv1000]

Good day,

I am trying to get the sum cumulative of a row but restarts if cell value is 0. What's the formula to get the Sum cumulative of product A? Column A is the name of the product and column b is the value. I don't know how to explain it but here's the example.


Product A 1
Product B 1
Product B 1
Product A 0
Product A 1
Product A 1

Sum Cumulative = 2

 

[James006]

Hi,
You can test in cell B8 following formula

=SUM(INDIRECT("B"&LOOKUP(2,1/(B1:B6=0),ROW(A1:A6))+1):B6)

 

[Fluff]

Hi & welcome to MrExcel.
What is the expected result if the data was like this
Product A 1
Product B 1
Product B 1
Product B 0
Product A 1
Product A 1

 

[eatv1000]

Hi & welcome to MrExcel.
What is the expected result if the data was like this
Product A 1
Product B 1
Product B 1
Product B 0
Product A 1
Product A 1

3 should be the result.

 

[eatv1000]

Hi,
You can test in cell B8 following formula

=SUM(INDIRECT("B"&LOOKUP(2,1/(B1:B6=0),ROW(A1:A6))+1):B6)

Thank you. I will check it when I get home.

 

[eatv1000]

Hi,
You can test in cell B8 following formula

=SUM(INDIRECT("B"&LOOKUP(2,1/(B1:B6=0),ROW(A1:A6))+1):B6)

A 0
B 1
B 1
A 1
A 1
A 1

Thank you for you response. I tried the formula above and the result is 5 when it should be 3 since I am only summing the Product A.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1
2	A	1		3
3	B	1
4	B	1
5	B	0
6	A	1
7	A	1
8
Lists

Cell Formulas
Range	Formula
D2	D2	=MAX(SCAN(0,FILTER(B2:B100,A2:A100="A"),LAMBDA(a,b,IF(b=0,0,a+b))))

Fluff.xlsm
	A	B	C	D
1
2	A	1		2
3	B	1
4	B	1
5	A	0
6	A	1
7	A	1
8
Lists

Cell Formulas
Range	Formula
D2	D2	=MAX(SCAN(0,FILTER(B2:B100,A2:A100="A"),LAMBDA(a,b,IF(b=0,0,a+b))))

 

[eatv1000]

How about

Fluff.xlsm
	A	B	C	D
1
2	A	1		3
3	B	1
4	B	1
5	B	0
6	A	1
7	A	1
8
Lists

Cell Formulas
Range	Formula
D2	D2	=MAX(SCAN(0,FILTER(B2:B100,A2:A100="A"),LAMBDA(a,b,IF(b=0,0,a+b))))

Fluff.xlsm
	A	B	C	D
1
2	A	1		2
3	B	1
4	B	1
5	A	0
6	A	1
7	A	1
8
Lists

Cell Formulas
Range	Formula
D2	D2	=MAX(SCAN(0,FILTER(B2:B100,A2:A100="A"),LAMBDA(a,b,IF(b=0,0,a+b))))

Thank you so much.
What if the data is like this?

A 1
B 1
A 0
B 1
B 1
A 0
A 1
A 0

 

[Fluff]

How about

=TAKE(SCAN(0,FILTER(B2:B100,A2:A100="A"),LAMBDA(a,b,IF(b=0,0,a+b))),-1)

 

[James006]

A 0
B 1
B 1
A 1
A 1
A 1

Thank you for you response. I tried the formula above and the result is 5 when it should be 3 since I am only summing the Product A.

Shame you did not mention " Only for A " in your first message ...