- Graphic and text skills li>
COUNT and COUNTIF are two very practical table functions that are used very frequently in daily work.
Why are these two functions so popular? Let's take a look at their respective uses.
The basic function of the COUNT function is counting, which can quickly count the number of cells in the data range. For example, if we need to count the number of candidates who submitted exam papers, we can use the following method:
Enter the formula =COUNT(selected data range)
in Excel to quickly get the result without having to count them manually one by one.
It should be noted that the COUNT function can only count numerical data, and data in text and other formats will not be counted.
If we want to count the number of cells under specific conditions, such as the number of students with scores greater than 40, we need to use the COUNTIF function.
The COUNTIF function counts cells based on given conditions. How to use it:
Enter the formula =COUNTIF(selected data range, "criteria")
in Excel, where the criteria needs to be enclosed in double quotes. For example, to count the scores greater than 40, the formula would be =COUNTIF(selected data range, ">40")
.
These two functions can help us greatly improve efficiency when studying or working.
评论列表(196条)
测试