:Use the COUNTA function to count the number of non-empty cells-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Use the COUNTA function to count the number of non-empty cells

Use the COUNTA function to count the number of non-empty cells

Author: daogeziyuan • • Table skills • Views 956
  • Picture and text skills
  • Case

Returns the number of cells with non-null values ​​in the parameter list. Use the COUNTA function to count the number of cells containing data in a range or array.


Grammar

COUNTA(value1,value2,...)

Value1, value2, ... are the values ​​to be calculated, and the number of parameters ranges from 1 to 30. In this case, parameter values ​​can be of any type, they can

Includes null characters ("") but not blank cells. If the argument is an array or cell reference, blank cells in the array or reference are ignored.

If you do not need to count logical, literal, or error values, use the COUNT function.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/qiao-yong-COUNTA-han-shu-ji-suan-fei-kong-dan-yuan-ge-ge-shu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 小晴天 Columnist
48 196
single-end

Related Suggestion