COLUMNS
TheCOLUMNS
formula returns the number of columns in a given range. This formula is most commonly used to find the number of columns in a table or range of data.
 How to use
COLUMNS
formula?  Examples of using
COLUMNS
formula COLUMNS
formula not working? Similar formulas to
COLUMNS
Usage
Use the COLUMNS
formula with the syntax shown below, it has 1 required parameter:
 range (required):
The range of cells to count the number of columns for. The range can include rows and columns.
Examples
Here are a few example use cases that explain how to use theCOLUMNS
formula in Google Sheets.
Counting columns in a table
The COLUMNS
formula can be used to count the number of columns in a table or range of data, which can be useful for various calculations and data analysis.
Dynamic column reference in formulas
By using the COLUMNS
formula in combination with other formulas, you can create dynamic references to specific columns in a table or range of data.
Conditional formatting based on column count
You can use the COLUMNS
formula to set up conditional formatting rules that are based on the number of columns in a table or range of data.
Common Mistakes
COLUMNS
not working? Here are some common mistakes people make when using the COLUMNS
Google Sheets Formula:
Incorrect range format
One common mistake is not using the correct range format in the COLUMNS formula. You need to make sure to specify the range using the A1 notation, separated by a colon. For example, A1:B10.
Using nonnumeric values
Another mistake is trying to use nonnumeric values in the range specified for the COLUMNS formula. Make sure to only include cells that contain numbers, or use a function to convert nonnumeric values to numbers.
Range outside of sheet
A common mistake is trying to specify a range that extends beyond the limits of the sheet. Doublecheck the range you are using to make sure it is within the limits of the sheet.
Incorrect function syntax
Make sure you are using the correct syntax for the COLUMNS function. The range parameter is required and should be enclosed in parentheses. For example, COLUMNS(A1:B10).
Empty range
If the range you are using for the COLUMNS formula is empty, the formula will return 0. Doublecheck that the range you are using contains data.
Related Formulas
The following functions are similar to COLUMNS
or are often used with it in a formula:

ROWS
The
ROWS
formula returns the number of rows in a specified range. It is commonly used to count the number of rows in a dataset or to create dynamic ranges. TheROWS
formula is a part of the Lookup category of functions. 
COUNT
The
COUNT
formula returns the number of numeric values within a specified range of cells. It is commonly used to count the number of entries in a given range that meet specific criteria, such as counting the number of sales above a certain threshold. 
COUNTA
The
COUNTA
function counts the number of nonempty cells within a specified range. It can take up to 30 arguments which can be individual cells or ranges. This function is commonly used to count the number of entries in a list or to determine the number of cells that contain data. 
SUMIF
The
SUMIF
formula is used to add up values in a range that meet a specific criterion. It can be used to sum values based on text, numbers, or dates. The formula is most commonly used in financial analysis, budgeting, and data analysis. 
INDEX
The
INDEX
formula in Google Sheets is used to return a value or reference of a cell at the intersection of a specified row and column in a given range. The formula is commonly used to lookup and retrieve values from a table or range of cells.
Learn More
You can learn more about the COLUMNS
Google Sheets function on Google Support.