COLUMNS function

Category:Search and reference

English name:COLUMNS

That makes?

Gets the number of columns in a range.

Syntax

COLUMNS (range)

  • range (required ): The range of cells for which you want to know the number of columns

Examples

COLUMNS (A1: E10) = 5
COLUMNS (G25: K30) = 5

Leave a Comment