Microsoft Excel
--
Questions
--
Followers
Top Experts
Needs Help With Inventory Tables
Hi everyone! I need help with my Inventory Management list. So I have a few tables and I need to fill these tables out based on First-In-First-Out(FIFO), Last-In-Last-Out(LILO) and Average costing. These tables and their costs have to be calculated based on the demand tables just on their right..
It is a very tedious task to fill these tables manually so I was hoping someone can suggest a solution that will help me save time now and in the future when I encounter similar work..
I have attached an example file with some of the data keyed in. Any help is much appreciated! :)
Q6.xlsx
It is a very tedious task to fill these tables manually so I was hoping someone can suggest a solution that will help me save time now and in the future when I encounter similar work..
I have attached an example file with some of the data keyed in. Any help is much appreciated! :)
Q6.xlsx
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Hi,
For Purchases you can use this function in cell M3 =IF(L3<>"",SUMIF(A$4:A$18,
I am not sure from which column I can sum the Sales, can you clarify?
For Purchases you can use this function in cell M3 =IF(L3<>"",SUMIF(A$4:A$18,
I am not sure from which column I can sum the Sales, can you clarify?
@abbas abdulla I think you can try it under Total Cost :)
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Hi I think you may have attached the wrong file :)
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Hi,
The file is same file you posted earlier (Q6) it has same name and content. I just updated the functions inside it!
The file is same file you posted earlier (Q6) it has same name and content. I just updated the functions inside it!
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.