STOCK BALANCE FORMULA BY SELECTED ITEM AND DATE

[yande]

Hi Master,

I don't know how to create a formula in excel to get an actual balance of stock referring the date and selected item.
Attached is the file of example of my work.



Please help me.
Thanks in advance.

 

[herofox]

hello

 

[yande]

hello

Hi master,

The result should be like this.

For example, the balance of pencil on 2nd jan was 100, because on 1st jan got in-stock 100.
Balance of the pencil on 20th apr was 70, because at 4th and 19th feb there's deduction of 20 and 10.

 

[herofox]

This post is a duplicate, located at this link
https://chandoo.org/forum/threads/bring-forward-stock-formula-in-excel.42771/
Please Merge it ,or Delete This Post

 

[vletm]

yande
Is this this same as above written?
If not then write Your reply to that other thread to get this open again.
This is closed now.