Excel formula

Hi, I am trying to count the number of transactions made by each person (multiple transactions made by each person) however some transactions in the list are not valid and i want to use a formula th...