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?

Entry Date Product Type Product Name In Out Bal Qty Qty Qty 1/4/2018 AD-DS ADG8529 100 0 ? 2/4/2018 BO-KG SN500 100000 ? 3/4/2018 DS-KG Diesel 100 ? 4/4/2018 EO-KG SAE50 26000 ? 5/4/2018 BO-KG SN500 25000 ? 6/4/2018 DS-KG Diesel -50 ? 7/4/2018 DS-KG Diesel -50 ? 8/4/2018 EO-KG SAE50 -26000 ? 9/4/2018 AD-DS ADG8529 -25 ? 10/4/2018 AD-DS ADG8529 -25 ? 11/4/2018 AD-DS ADG8529 200 0 ? <colgroup><col><col><col><col><col span="2"></colgroup><tbody> </tbody>

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

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