Total columns in range

An excel formula to total columns in range

Related Functions

Sponsored Link

 Total columns in range
=COLUMNS(rng)

If you need to count the number of columns in a range, use the COLUMNS function. In the generic form of the formula (above) rng represents a range of cells.

In the example, the active cell contains this formula:

 
=COLUMNS(B4:C9)

Here's how the formula works:

COLUMNS counts the number of columns in and returns the result as a number.

Sponsored Link

0 votes. 0 / 5