First step is to highlight the range of data, then use Data-Filter-Advanced
filter.
Choose to Copy to a new location, and check Unique records only.

Now assuming your two original columns are in A & B, and the unique,
filtered data is in colmns D & E, both starting in row 2, use this formula in
F2 and copy it down

=SUMPRODUCT(--($A$2:$A$92=D2),--($B$2:$B$92=E2))

adjust the ranges to reflect your own data