Count If

[KLock]

I would like to setup a count function that counts by position for specific
type. For example:
Position Type
1 a
2 a
3 c
2 c
3 b
1 a
Function Calculates:
1a = 2
2a = 1
3a = 0
1b = 0
And so on. How can I setup the calculation functions?
Thanks

 

[Max]

One way
In C2: =SUMPRODUCT((A$2:A$100=A2)*(B$2:B$100=B2))
Copy down