Sep 27 2022 06:29 PM
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?