counta

counta

1

Also , if the columns used for the data contain any other entries , COUNTA will return an incorrect value .

另外，如果数据使用的列包含其他数据，COUNTA将返回一个错误值。
2

To use this technique for your own data , make sure that the first argument for the OFFSET function refers to the first data point , and that the argument for COUNTA refers to the entire column of data .

为了将此技术用于你自己的数据，确保OFFSET函数的第一个变量指向第一个数据点，COUNTA的变量指向数据的整列。