I have created stock report. Now, I using dropdown list for "Opening balance", "Inward", "Outward" and "closing balance" in column and put values separately in different columns for all three options.
Now, I want calculate the closing stock at the end of each day. for this, I have to sum values in "Opening Bal." column with sum of values "Inward" column and then subtract the sum of values in "Outward" column of entire day. I have to perform same at the end of the day.
My problem is that is there way or function i put so it calculate closing stock values automatically when i put a drop-down option as "Closing Stock".
And It should only sum the values of "Opening balance", "Inward" and "Outward" before previous "Closing Stock".
26 freelanceria on tarjonnut keskimäärin ₹6885 tähän työhön
I can work for you better than everyone else. Hire me and u gonna be surprised with my result. I am currently studying and got leisure time. So i wanna earn
I am in CA final, great skill in MS Excel and other Data related work. Best and fast typing skill , done Audit of many listed companies, so better at time managment and skills.