I have a situation where I need to count the total number of instances of values in a column and return the results in other cells.
Users are going to be provided this Excel sheet as a template and will choose from a dropdown list in a specific column.
For example in Column A, the 'Clothing' column, the user would choose any one of these values:
Bra Dress Pants Shirt Shoes Shorts Socks T-Shirt Thermal Underwear Underwear
And they will have a different number of each item each time.
So ideally I could total up every instance of each term. Then in another column I could return any number above 0, along with the term, like so: 'Bra: 4'. This value would be received later when the file is submitted.
I searched around and tried using the COUNTIF function. I can get this to work generically if I drag it down along side the Clothing column, but the users will submit this themselves, so I need it to do this as automatically as possible.
I made a named range of the terms way out in cell AA in order to make the dropdown, but I couldn't get the function to check the named range, and I'm not sure if I can do that at all.
Can anyone shed some light here? Thanks much and please let me know if more info is needed.