Iterative Sum Calculation
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 |
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 |
All times are GMT +1. The time now is 02:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com