If Formula

[eramirez148]

How can I get the results in column D. Lets say right now column B has a formula =Sales/amount received to get the percentage sold from the amount received. However, when I drop the formula down the percent results are uniquely to the sales and amount received. If the item repeats itself then I want the percent result to accumulate and add previous days.

Column A	Column B	Column C	Column D
Item 1	10/1/2024	10	10
Item 1	10/2/2024	10	20
Item 1	10/3/2024	10	30
Item 1	10/4/2024	10	40
Item 2	10/1/2024	5	5
Item 2	10/2/2024	5	10
Item 2	10/3/2024	5	15
Item 2	10/4/2024	5	20
Item 2	10/5/2024	5	25

 

[DanteAmor]

Try:

Libro1
	A	B	C	D
1	Header1	Header2	Header3	Header4
2	Item 1	10/01/2024	10	10
3	Item 1	10/02/2024	10	20
4	Item 1	10/03/2024	10	30
5	Item 1	10/04/2024	10	40
6	Item 2	10/01/2024	5	5
7	Item 2	10/02/2024	5	10
8	Item 2	10/03/2024	5	15
9	Item 2	10/04/2024	5	20
10	Item 2	10/05/2024	5	25
Hoja2

Cell Formulas
Range	Formula
D2:D10	D2	=IF(A1=A2,D1+C2,C2)