Sum or substract data based on the data of the secound table
this is my stock table i have to do all this work by hand it would be lovely if i can get some help with the formula
So, my stock is loaded, unloaded, Packed or what not
hence if possible to add or substract data based on conditions of the secound table that whould be wonderful
and if anyone can show me there way of keeping record of stock, i'd love to know how other people maintain it
Balance needs to become Amount, then you need to add a Balance column:
Subtract is misspelt in your workbook - I have gone with the misspelling.
Please Login or Register to view this content.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
That was not quite right - slight amendment:
Please Login or Register to view this content.
There are some problems with the balance amount,. And thankyou very much for replying...
please check the attachment file
Did you see post #3?
i Totally didn't see the secound reply...
Thanks a lot for the help
if it's not a hassel can you show me how you keep records of stock/inventory
I don't have any stock or inventory to keep records for - sorry. In any case, it would require a new thread.
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.
Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks