I have 2 pages on my spreadsheet. The first is a "Totals" page and the other page is the breakdown of all the parts, prices, quantities, etc. I would like for a cell on the first page to be able to calculate the quantities of parts from the second page.
So it might look like this:
Column A Column B
ABC123 58
ABC234 64
ABC234 69
ABC123 102
So, I want it to lookup all the "ABC123" parts in Column A and add the quantities listed in Column B associated with that part #. Any suggestions?
Last edited by halvy52; 08-16-2011 at 04:41 PM.
Your formula will look like the following:
Of course, modify the range to meet your data. And you can also search for data as a cell reference. For example, if ABC123 is entered in Cell D3, your formula can look like:
Please Login or Register to view this content.
Please Login or Register to view this content.
Will this formula also add the quantities from Column B?
So it sees 2 cells listed as "ABC123" so it needs to add up the 2 quantities associated with them in Column B.
Wait, I apologize. I gave you the wrong formula. It should have read the following:
This adds up each quantity in column B where the value in column A is "ABC123"Please Login or Register to view this content.
Let me know if this helps
Actually both formulas helped me. Thanks a lot. Appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks