I have a spreadsheet of inventory with multipe part numbers in columns and the piece count in an adjacent column. How can I look up a certain part number and get a total piece count? Thank you for any help!
I have a spreadsheet of inventory with multipe part numbers in columns and the piece count in an adjacent column. How can I look up a certain part number and get a total piece count? Thank you for any help!
Take a look to COUNTIF function.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi. Thank you for responding. Is there anyway you could break this down for me? Say I wanted part #45's piece count. How do I input that into COUNTIF?
Unfortunately your request is not clear.
Pls upload a sample workbook.
You can probably solve this with an pivot table, but as already said,
you don't add an excel example, so i can't show you.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi nborob
Suppose you have a list of parts in cells A1:A14 and you wanted to know how parts with part no. #45, were in that list, as Fotis pointed out, use the COUNTIF.
Formula:Please Login or Register to view this content.
Or you could have the search criteria in a cell, so you could reference that cell.
In C1 is #45
Formula:Please Login or Register to view this content.
Have a look here.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks