LinkBack URL
About LinkBacks
I have two sheets one for stock and one for orders
the stock sheet has a column called amount sold, i need this column to look up the information on the orders page and show how much has been sold.
i have attached by workbook if it helps
I have two sheets one for stock and one for orders
the stock sheet has a column called amount sold, i need this column to look up the information on the orders page and show how much has been sold.
i have attached by workbook if it helps
Try:
=SUMIF(Orders!G:G,$A9,Orders!M:M)
copied down
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi
Assuming that column M on the orders sheet is what you mean by 'sold' then in E9 of the Stock sheet copied down:
If not col. M then just change the reference.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks