Hi All,
I'm putting a Uniform Inventory sheet in place and I need your help. As you can see, i'm looking for a total count of how many of each sizes I have. As an example, I need the cell E2 to show 12. Q.JPG
Hi All,
I'm putting a Uniform Inventory sheet in place and I need your help. As you can see, i'm looking for a total count of how many of each sizes I have. As an example, I need the cell E2 to show 12. Q.JPG
Hi and welcome to the forum
Just for future reference, please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
having said that, in D3, copied down, use this...
=IFERROR(INDEX($B$3:$B$9,MATCH(0,INDEX(COUNTIF($D2:D$2,$B$3:$B$9),0,0),0)),"")
and then in E3, copied down, use this...
=SUMIF($B$3:$B$9,D3,$A$3:$A$9)
adjust ranges as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you. This was my first time posting.
I've done what you said, but the count is incorrect. Attached is the file.
Nevermind. That worked. Thank you so much. You saved my weekend!
J
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks