Count number of occurences

[pedrotairum]

Hello there,

So I would like to count the number of occurrences some index presents itself regarding one letter.
Let me make this more clear, I have the following table:

A 1
A 1
A 2
B 1
B 2

And I want the output to tell me something like - For the letter "A" I have two occurrences of the number 1 and one occurrence of the number 2. For the letter "B" I have one occurrence of the number 1 and one occurrence of the number 2.

Thank you very much for your time!

[pareshj]

Hi,

You can use Pivot table to achieve the same.


Regards,
Paresh J

[Miroslav R.]

Hi there,

You can use COUNTIFS.

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)