getting total number of items sold from a list

I have a list of orders, all of which have a ProductID and I want to pull out the totals for each individual item by ID to compare popularity. How can I do this?

Thanks

It's difficult to give you an exact formula without seeing how your data is laid out, but if you list all your product IDs in a separate table then you will be able to use a SUMIF formula to get totals for each, and then you could use RANK to get the most popular.

Hope this helps.

Pete