Excel formula

Occasional Visitor


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?

2 Replies

@IsaH2000 And how would you identify invalid transactions?


Use COUNTIFS() or a pivot table.