在excel中，如何计算一列中每个值的出现次数，并将其按另一列中的值进行分组

I need to count the occurrence of each value in one column and group it by values in another. How would I do this?

我需要计算一列中每个值的出现次数,并将其按另一列中的值进行分组。我该怎么办?

1 个解决方案

#1

The following SUMPRODUCT will work:

以下SUMPRODUCT将起作用:

=SUMPRODUCT(($A$2:$A$6=H$1)*(ISNUMBER(SEARCH($G2,$B$2:$B$6))))