Inventory management sheet formula require

[yasirmhmd8]

My requirement mentioned in my excel sheet. INVENTORY.xlsx

[AliGW]

Please explain the issue. Nobody should have to open the attachment to find out what is required. Thanks.

[yasirmhmd8]

mam its new sheet which are similar with my previous requirement. mam it is my inventory sheet which i am using in my work place. i mentioned complete details in my sheet. kindly solve my problem and once again i am sorry and apologize for inconvenience. thanks

[AliGW]

Do not assume that anyone reading this thread has followed your earlier thread. Each thread is separate from each other. This is the detail that I want to see in your threads (NOT just hidden in attachments):

I have a bulk store and also have ten different shops, each shop has some authorized quantity. When I received quantity of something so according to authorization of shops we sent them. If First shop received full quantity as per authorized it will count zero( zero mean its filled), and those who have received full quantity they will also count zero. Those who do not have receive full quantity mean deficient received they will count remaining quantity, which they will have received next time according to under mentioned: example No-01 Bulk store in cell no C18 receive 10 quantity and sent to shop#01 in cell no E18, and shop#01 received full quantity according to authorization cell D16. As you know we was required 30 quantity to fill these 10 shops but we received less quantity now we cannot it. so remaining shops who do not have received full quantity they will count their Deficient Quantity in example cell H18 we received 2 quantity remaining 1, we will count only remaining quantity same like other shops. i need simple excel formulas please.

[yasirmhmd8]

now what can i do for this? please tell me

[yasirmhmd8]

I have a bulk store and also have ten different shops, each shop has some authorized quantity. When I received quantity of something so according to authorization of shops we sent them. If First shop received full quantity as per authorized it will count zero( zero mean its filled), and those who have received full quantity they will also count zero. Those who do not have receive full quantity mean deficient received they will count remaining quantity, which they will have received next time according to under mentioned: example No-01 Bulk store in cell no C18 receive 10 quantity and sent to shop#01 in cell no E18, and shop#01 received full quantity according to authorization cell D16. As you know we was required 30 quantity to fill these 10 shops but we received less quantity now we cannot it. so remaining shops who do not have received full quantity they will count their Deficient Quantity in example cell H18 we received 2 quantity remaining 1, we will count only remaining quantity same like other shops. i need simple excel formulas please.

[yasirmhmd8]

kindly tell its fine now?

[AliGW]

It's fine now, but I really should not be having to repeatedly ask you to explain the issue in detail in your opening post. In future, please do this without having to be asked. Thanks.

[yasirmhmd8]

Thanks mam, i apologize for this once again. I don't want to be it happened.next time i will be careful. Thankx

[JeteMc]

If I understand correctly then cells F18:O21 should be filled with the deficit for the particular item in that store.
That being the case the following could be placed in cells F18:O21 =IF($C18-$D18*(COLUMNS($A$1:A$1)-1)>$D18,0,MIN($D18,$D18-($C18-$D18*(COLUMNS($A$1:A$1)-1))))
The following could be used for E18:E21 =O$17*D18
The following could be used for P18:P21 =SUM(F18:O18)
The following could be used for F22:O22 =SUMPRODUCT(--($D18:$D21=F18:F21))
The following could be used for F23:O23 =COUNT($E18:$E21)-F22-F24
The following could be used for F24:O24 =COUNTIF(F18:F21,0)
Note that F22:O24 are custom formatted 0 "/4"
Let us know if you have any questions.

[yasirmhmd8]

sir thank you very much. this is absolutely right for, me one more thing added in this sheet, i highlighted it with orange color. kindly solve this. Please. Thank you.

Attachment 659411

[JeteMc]

Selecting Attachment 659411 in post #11 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator"
Please follow the instructions in the banner at the top of the page to upload an .xlsx file (screen shots are not useful).
Let us know if you have any questions.

[yasirmhmd8]

thanks a lot both of you. i am thank full to you. you solved my Query better guide me for my inventory sheet. once again thank you very much.

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.