# Creating a field for accumulated figure

#### Peterso

##### Board Regular
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

### Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

#### Anand Sharma

##### Board Regular
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

##### Well-known Member
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

Replies
9
Views
237
Replies
4
Views
308
Replies
2
Views
264
Replies
2
Views
157
Replies
10
Views
243

1,130,119
Messages
5,640,218
Members
417,131
Latest member
Seanr19871

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back