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 that will only count the transactions that are valid. 

Currently I am using COUNTIF to count the number of times that each person made a purchase but this is also picking up invalid purchases. How can i fix this?