Formula calculation stock

[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

[davsth]

how do you get to 30 and 35? what is the reasoning?

[davsth]

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)

[roykana]

how do you get to 30 and 35? what is the reasoning?

It is total quantity for each product A & B

[roykana]

It is total quantity for each product A & B

Quantity available of stock

[davsth]

and available stock is defined as?

[roykana]

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

[roykana]

Dear all master,

Please help me

Thanks

Roykana

[roykana]

Dear all master,

Please help me

Thanks

Roykana

[AliGW]

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.

[roykana]

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

[AliGW]

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?

[roykana]

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

[AliGW]

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.