이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
COLUMNS(array)The COLUMNS function counts the total number of columns within a specified range or array. It is commonly used to determine the width of a dataset or to create dynamic references in complex formulas.
=COLUMNS(A1:C5)결과: 3
Returns 3 because the range A1:C5 spans three columns (A, B, and C).
No, the COLUMNS function expects a single reference or array and will return an error if multiple non-contiguous ranges are provided.