Hello everyone, I'm a computer enthusiast, welcome to my sharing space, if you like my sharing, you can like and follow the collection, thank you. I haven't updated it for many days, and the next thing is to share the space.
Today's content is about a few functions of basic statistics.
1. What are the basic statistical functions?
1. Count function.
2. counta function.
3. Countblank function.
4. Countif function.
5. Countifs function.
2. What is the significance of these functions?
1. count function: calculate the number of cells containing numbers in the area.
2. Counta function: count the number of non-empty cells in a certain area3. Countblank function: count the number of empty cells in a certain area.
4. countif function: calculate the number of cells in a certain area that meet the conditions.
5. countifs function: count the number of cells specified by a given condition.
3. What is the format and application of these functions?
1. count function: =count(region), the range is the range of cells, for example, b2:b40
2. counta function: =counta (region), such as the count function is the same.
3. Countblank function: =counta (region), if the count function is consistent, the condition is set by yourself.
4. countif function: =countif(region, condition), the region is consistent with the count function, and the condition is set by yourself.
5. countifs function: =countifs(Condition 1 corresponds to the region, Condition 1, Condition 2 corresponds to the region, Condition 2 corresponds to the region,......If the count function is the same in the region, the conditions can be set by yourself.
Well, that's all for today.
On the way to continuous learning, friends cheer together.