Accumulative Sum for Same Product with Same Packing

[mmm1199]

Hi guys, does anyone know how to get the accumulative sum for same product type and name within a list?
[TABLE="width: 713"]
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 713"]
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Entry Date[/TD]
[TD]Product Type[/TD]
[TD]Product Name[/TD]
[TD]In[/TD]
[TD]Out[/TD]
[TD]Bal[/TD]
[/TR]
[TR]
[TD]Qty[/TD]
[TD]Qty[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]1/4/2018[/TD]
[TD]AD-DS[/TD]
[TD]ADG8529[/TD]
[TD]100[/TD]
[TD]0[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]2/4/2018[/TD]
[TD]BO-KG[/TD]
[TD]SN500[/TD]
[TD]100000[/TD]
[TD] [/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]3/4/2018[/TD]
[TD]DS-KG[/TD]
[TD]Diesel[/TD]
[TD]100[/TD]
[TD] [/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]4/4/2018[/TD]
[TD]EO-KG[/TD]
[TD]SAE50[/TD]
[TD]26000[/TD]
[TD] [/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]5/4/2018[/TD]
[TD]BO-KG[/TD]
[TD]SN500[/TD]
[TD]25000[/TD]
[TD] [/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]6/4/2018[/TD]
[TD]DS-KG[/TD]
[TD]Diesel[/TD]
[TD] [/TD]
[TD]-50[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]7/4/2018[/TD]
[TD]DS-KG[/TD]
[TD]Diesel[/TD]
[TD] [/TD]
[TD]-50[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]8/4/2018[/TD]
[TD]EO-KG[/TD]
[TD]SAE50[/TD]
[TD] [/TD]
[TD]-26000[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]9/4/2018[/TD]
[TD]AD-DS[/TD]
[TD]ADG8529[/TD]
[TD] [/TD]
[TD]-25[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]10/4/2018[/TD]
[TD]AD-DS[/TD]
[TD]ADG8529[/TD]
[TD] [/TD]
[TD]-25[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]11/4/2018[/TD]
[TD]AD-DS[/TD]
[TD]ADG8529[/TD]
[TD]200
[/TD]
[TD]0[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
12/4/2018 BO-DS SN500 500 ?

 

[help needed yes please]

Frank : Hi AhoyNC. My formula was same asyours so looked for my bad. Found input errors. All good now however this time aroundI see your column ‘H’ gives ‘in’ totals, could you pass along that formula. Ishall try to see how you make the difference. . Also I see likes and thanks onthread heading but cant see how to actually do it so if you could point me inthat direction it would be appreciated. Thanks, f<o></o>

 

[help needed yes please]

frank above all working good. Thanks. Could you pass along the formula for column 'H' have a good day.

 

[AhoyNC]

The formula is shown in post #10 . It's just:

=SUMIFS($D$3:D3,$B$3:B3,B3,$C$3:C3,C3)

copy down column as needed.

As far as LIKE & THANKS you just click on them at the bottom of the post.

 

[help needed yes please]

Frank. Thanks you are a 'bobby dazzler' good stuff, all good ta f