I am struggling with this one for a week now: Example: Column A is list of IP addresses, Column B is a list of red flag or bad ips. Does someone knows the formula so i can count how many Bad ips are in list that is in Column A? Here is a Screenshot: [1]: