Hi
If you look at the attachment this will be easier to understand
On tabs 1, 2, 3 & 4, there is a list of products, their stock and how much stock is required
On tab "Total Needed" I have manually filled out the information based on the information in tabs 1-4
I need anything that has a value greater than Zero in tabs 1-4 to be in a list on the tab "Total Needed", along with the product name
So i require formulae for the "Total Needed" tabs please, in columns A & B
Thanks in advance
The way I can think of that this might be accomplished using the 2007 version of Excel is to make a list of all products and index them using formulas like:Formula:
Please Login or Register to view this content.
An aggregate is then produced using the SUM function.
For the final output the 'Product' column is populated using:Formula:Please Login or Register to view this content.
The 'Quantity Needed' column is populated using:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you, i'll give it a try when i get a chance. there is a lot more data in my original spreadsheet so i'm hoping it can transfer your formulae over to it.
You're Welcome and thank you for the feedback. If the method works with your original spreadsheet, 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks