[FAQ000163]I can’t specify an entire column when using CELF functions to specify a range.

Q

In Excel, the range of various functions can be specified for the entire column, such as "A:A",

but in CELF, the entire column could not be specified in the same way.

How can I specify the entire specified column on a sheet as the range of a function?

A

CELF does not support the specification of an entire column such as "A:A",

so it is necessary to specify the range of all rows in the target column.

e.g.) When the maximum number of rows in a sheet is 50 and the entire column A is specified in the SUM function

　=SUM(A1:A50)

Related keywords

Specify range