Excel2010 function Explanation--countifs

① First we open Excel, I was to show you, so I randomly input some data to illustrate.

② below, we have to figure out the number of American cities with more than 20 enrollment, which of course uses the countifs.

③ after the cell has entered a function, the system prompts the function parameter, Criteria_range1, which indicates the range of the condition 1, where we enter the A3:A11.

④ followed by the Criteria1 parameter, we entered the United States.

⑤criteria_range2 represents the range of the condition 2, the input c4:c11,criteria2 said condition 2, according to the request, here definitely fills in the >20.

⑥ the parameters are separated by commas, the conditional parameters are enclosed in quotation marks, the final input function, press ENTER to get the result of calculation. If the calculation is incorrect, check to see if it is entered in the English half-width, and do not enter the formula in another input format.