To all masters,
Please help me to make the formula in columns E, F AND G which I marked yellow. I ask for 2 solutions for the first and second processes. Please help and thank you
Thanks
Roykana
To all masters,
Please help me to make the formula in columns E, F AND G which I marked yellow. I ask for 2 solutions for the first and second processes. Please help and thank you
Thanks
Roykana
how do you get to 30 and 35? what is the reasoning?
Perhaps j4 is =SUMIF($C$4:$C$11,I4,$E$4:$E$11)
as it equals 30 but you have not explained why!
and j5 is
Perhaps j4 is =SUMIF($C$4:$C$11,I5,$E$4:$E$11)
and available stock is defined as?
So in columns j4 and j5 are the quantity of stock available and in columns e, f, g then it is used as an analysis of the order quantity with the existing stock assessments.
So I want the yellow markings to use a formula so I don't need a manual.
Thanks
Roykana
Dear all master,
Please help me
Thanks
Roykana
Dear all master,
Please help me
Thanks
Roykana
You still haven't told us exactly how you have mentally calculated the quantity on hand of 30 x A and 35 x B.
Explain EXACTLY how you mentally calculate 30 in cell J. Until you do this, nobody can help.
Last edited by AliGW; 02-20-2020 at 10:15 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
In columns j4 and j5 are the last amount of stock that I marked green.
So that was the result of the last stock on 10-02-2020.
Please Help me
Thanks
kana
Last edited by AliGW; 02-20-2020 at 10:20 AM. Reason: Please don't quote unnecessarily!
I cannot help you until you give the information I need.
There are no entries for that date, so why should the results be 30 and 35 respectively? And how wis Excel meant to know about that date?
I want to monitor the number of orders from the last stock so that I can determine which items can be sold and can also be produced. So I want the formula in columns e, f, g that I marked yellow by taking the last stock from columns j4 & j5 that I marked green
No, sorry - you aren't making this clear at all. Sorry - I can't help unless you tell me how you are calculating those values. I cannot see what your logic is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks