COUNTIF operates by evaluating a range of cells and counting how many of those cells meet a given condition. For instance, if you wanted to count how many subscribers opened an email, you could use COUNTIF to tally the cells that contain the value "opened". The syntax generally looks like this: =COUNTIF(range, criteria)