In Excel, the COUNTIF function will give you the answer.
Assume your data above is in a block of cells from A5 to B102.
Create a block of “criteria” cells, say in H6 … H10 as follows:
(extend as needed)
In the next column (I6 … I10), enter the formula:
Enter that in I6, then copy and paste down to I10, which will change the references H6 and H7 to the appropriate cells.
Voila – the table in H6:I10 now contains your results with counts.
I am a little puzzled by your source data, which shows the same IP addresses with different counts. If you need to sum the counts for a given IP address first, that is a different question.