15 Tem 2019 ... For example, when we want to count the number of times a salesperson exceeded their target, we can do this by using COUNTIF. Formula. =COUNTIF( ...