COLUMN Function in Google Sheets: Syntax, Examples & Troubleshooting

• Introduced: Original introduction date is not established by the official history reviewed.
• Availability: Documented in the rolling Google Sheets service. This guide covers ordinary worksheet formulas in the web workflow; it does not establish separate mobile or connected-database behavior.
• Checked: October 14, 2026, against the official COLUMN reference. Documentation and independent calculations; no native application execution.

=COLUMN([cell_reference])

The reference is optional. When omitted, COLUMN uses the cell containing the formula. For a multi-column reference outside array-formula use, Google’s documentation says it returns the first column’s position.

Use actual references such as F8, not quoted address text, in these examples. A dollar sign changes how a reference adjusts when the formula is copied; it does not change the column number at the current location.

Enter these formulas in separate empty cells:

=COLUMN(A9)
=COLUMN(F8)
=COLUMN(AA2)
=COLUMN($D$20)

The expected results are 1, 6, 27, 4. The row numbers 9, 8, 2 and 20 have no effect on which column is being identified. The referenced cells do not need numeric contents or even visible data for this location-based task.

Comparing F8 with F100 should still produce 6 in both cases. This simple control helps detect a mistaken reference rather than a problem with the function itself.

Enter =COLUMN() in H2. The expected result is 8. Enter the same formula in K2 and the expected result is 11. No explicit reference is supplied, so the containing cell determines the answer.

This behavior is useful for location-aware formulas but makes a moved formula change meaning. If a report must always describe column H, write =COLUMN(H2) or an appropriately fixed reference rather than relying on the formula’s current position.

=COLUMN(C5:F5)

Outside an array formula, the expected result is 3, the position of column C. The selected range spans four columns, but COLUMN does not return four for that reason.

For a width count use the separately documented COLUMNS function. A single-cell range in column C has the same first-column coordinate as C5:F5, even though their widths differ.

Suppose a report’s three period columns occupy C5:E5. In C7 enter:

=COLUMN(C5)-COLUMN($C$5)+1

Fill it across through E7. The expected results are 1, 2, 3. The moving reference contributes positions 3, 4 and 5. The fixed starting reference always contributes 3. Subtracting the start and adding one converts absolute worksheet coordinates into one-based positions within the report.

Without the plus one, the outputs would be 0, 1 and 2. Either convention can be useful, but use the one expected by the next function. Spreadsheet lookup column indices commonly start at one.

=ARRAYFORMULA(COLUMN(C5:F5))

The expected output is a one-row array 3, 4, 5, 6. This uses an explicit ARRAYFORMULA wrapper to request array behavior rather than relying on the scalar first-column rule.

Subtracting COLUMN(C5) and adding one inside the same wrapper produces relative positions 1, 2, 3, 4. Reserve all four output cells. A formula that displays only 3 has not reproduced the complete array expectation.

Do not confuse the returned number with a source value: if F8 contains 200, COLUMN(F8) is still 6. Do not use COLUMN to count fields in a CSV line; SPLIT and a width calculation address a different question.

A multi-cell reference, a copied relative reference and an omitted reference are three separate cases. Test each deliberately. Deleting or rearranging source columns may change the references your report follows, so inspect the resulting formulas after structural edits.

All coordinates and relative-index outputs above were independently calculated. No native Sheets execution is claimed, including the explicit array-formula case. The formulas are written for a comma-separator locale where needed. For row-oriented layouts, ROW performs the corresponding coordinate task; SEQUENCE can generate ordinary numbering without depending on worksheet location.

• Google Docs Editors Help: COLUMN
• Editorial testing standards