How to Use Excel Countif

1. Select the desired cell on the spreadsheet to display the calculated formula.
2. Type '=countif(' and select the range of cells to be evaluated by clicking the first cell, holding down the mouse button and dragging the cursor to the last cell before releasing the mouse button.
3. Type ',' and then identify the criteria for counting each cell's content as 'TRUE' for one point, making sure to enclose characters between quotation marks. For example, type 'purple' within quotation marks to count those cells containing the word; type '>9' within quotation marks to count the number of cells containing a number above nine; type A2 to count those cells containing information matching the contents in cell A2.
4. Type ')' and then press the 'Enter' key to complete the formula.