Creating a field for accumulated figure

[Peterso]

I have field 1 being the Product code, field 2 being the transaction dates, field 3 being the quantity buy/sold. I want to create a field 4 which is the accumulated quantity of a product in a month. How can I do that? Thx

 

[Anand Sharma]

I suggest to insert an addition field to extract month using month(b2) formula and then use sumif function to get total quantity sold in a month

code	date	qty	month	sold in Month
101	1/1/2016	1	1	7	SUMIF($D$2:$D$7,""&D2,$C$2:$C$7)
102	1/2/2016	2	1	7	SUMIF($D$2:$D$7,""&D3,$C$2:$C$7)
103	1/31/2016	4	1	7	SUMIF($D$2:$D$7,""&D4,$C$2:$C$7)
104	11/1/2016	5	11	18	SUMIF($D$2:$D$7,""&D5,$C$2:$C$7)
105	11/15/2016	6	11	18	SUMIF($D$2:$D$7,""&D6,$C$2:$C$7)
106	11/30/2016	7	11	18	SUMIF($D$2:$D$7,""&D7,$C$2:$C$7)

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[james_lankford]

I suggest to insert an addition field to extract month using month(b2) formula and then use sumif function to get total quantity sold in a month

...

wrong language