Excel Formula for tracking remaining QTY

[ushaanu]

HI all,

I need some Excel Formula Solution For Daily Tracking . I have one stock Report with me in this report every branch having some Stock I need if somebody consuming Qty Automatically deduct from total QTY

Sample File enclosed

 

[bosco_yip]

1] Try Sumif function

2] See attached file

Regards
Bosco

 

[rahulshewale1]

hii @ushaanu ,

See if is it ok using Name range .

Select C8:E21,Go to formula tab >Create from Selection >Select Top row >>Ok
Use formula D2 COPY DOWN=C2-SUM(INDIRECT(B2))


Regard
Rahul shewale

 

[rahulshewale1]

hii @@ushaanu ,

pfa sheet.


Regard
Rahul shewale

 

[ushaanu]

Thank you so much Rahul