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
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