Elementary explanation of countif function in Excel2007

① first step, we open the Excel form and import the courseware I made, as shown in the following figure.

② below, I want to calculate the number of a5:c7 cells greater than 50, you can use the COUNTIF function. Enter a function formula in any cell: =count (A5:C7, ">50"), let me give you a concrete description of the meaning of each parameter of the function: A5:c7 represents the range of cells, >50, which indicates the number of cell values greater than 50.

③ returns, and for other uses of the COUNTIF function, we'll teach you in the next series of function tutorials.