Iterative Sum Calculation
On Tuesday, 14 May 2019 08:00:24 UTC+1, wrote:
Hello,
I have a Situation in sheets wherein I need to find if a particular stock has been fully used up
Eg:
Stock A -- Code1 -- 250units---0(balance)<----[250-100-100-50]
Stock used --- 100 units---Stock A(code 1)
Stock used --- 100 units---Stock A(code 1)
Stock A -- Code 2 -- 300 units---60(balance)<----[300-30(prev.balance)-80-150-60]
Stock used --- 80 units---Stock A(code 1+ Code 2)
Stock used --- 150 units---Stock A(code 2)
Stock used --- 60 units---Stock A(code 2)
Any help would be much appreciated
thanks
Rakesh.K
Hi
Create a table as below, and call it Stocks
A B C
Balance -20
Stock Code Units
A 1 250
A 1 -100
A 1 -100
A 1 -50
A 2 300
A 2 -30
A 2 -80
A 2 -150
A 2 -60
Name the
The formula in cell C2 should be =SUBTOTAL(109,Stocks[Units])
Then filter for Stock and code, and cell C2 will give the current balance
|