How to count times in Excel

excel statistics

When there is a lot of data in excel and a certain data appears repeatedly, you need to count the number of times it appears, you can use Go to the countif function to solve it directly. This article uses this function to count the number of occurrences of a certain function.

Recommended tutorial: excel tutorial

Syntax:

countif（range，criteria）

where range represents the area in which the number of non-empty cells is to be calculated

Among them, criteria represent conditions defined in the form of numbers, expressions or text

Using this example to illustrate how to count the number of times "Zhao Si" appears.

Input =COUNTIF(A2:A14,"Zhao Si") in cell E2, where A2:A14 represents the statistical area, and Zhao Si needs to be enclosed in quotation marks. Indicates the conditions to be counted.

After pressing Enter, the result is 3, which is consistent with the number in the previous area.

Notes

The "Zhao Si" quotation marks in the countif function are half-width, otherwise the function is wrong.

The above is the detailed content of How to count times in Excel. For more information, please follow other related articles on the PHP Chinese website!