TOTAL BY LIST OF ALL MENU (text) occurences

[bradlf]

I have a spreadsheet of articles sold on eBay and would like to total by list and number of items sold. Column C list each item (no quantity column - multiple items are simply listed twice, etc.) So I would like to generate a list with each "menu item" followed by the number of times it shows up in the spreadsheet. Is this fairly simple?
Thanks
Brad

 

[acw]

Brad

How about using the advanced filter to extract a unique list of items, then use the COUNTIF function to perform a count of the items.


Tony

 

[bradlf]

Thanks - works great!