使用Excel数据透视表对列表中的项目进行计数

If you have a long list of items, you could use formulas to count how many times each item occurs in the list. It would take a few steps, including pulling a list of unique items from the list, then creating a formula to count each item. Is there an easier way?

如果项目列表很长，则可以使用公式来计算每个项目在列表中出现的次数。 这将需要一些步骤，包括从列表中拉出唯一项目列表，然后创建一个公式来对每个项目进行计数。 有更容易的方法吗？

I find it quicker and easier to create a pivot table to count the list items. You'll have to add a heading to the list, if there isn't one already. Then, create a pivot table from the list, with the same field in the Row Labels area and the Values area.

我发现创建枢纽分析表来计算清单项目更快更容易。 如果还没有标题，则必须在列表中添加标题。 然后，从列表创建一个数据透视表，在“行标签”区域和“值”区域中具有相同的字段。

观看视频 (Watch the Video)

To see the steps for using a pivot table to count items in a list, watch this short video.

要查看使用数据透视表对列表中的项目进行计数的步骤，请观看此简短视频。

演示地址

翻译自: https://contexturesblog.com/archives/2010/04/21/count-items-in-list-with-excel-pivot-table/