Exceljet

Quick, clean, and to the point

Total columns in range

Excel formula: Total columns in range
Generic formula 
=COLUMNS(rng)
Summary 

To count the number of columns in a range, use the COLUMNS function. In the example shown, the formula in F6 is:

=COLUMNS(B5:C10)
Explanation 

The COLUMNS function is fully automatic. When you provide a range to COLUMNS, it will return a count of all columns in the range. In the example, the formula in F6 returns 2, because there are 2 columns in the range B5:C10:

=COLUMNS(B5:C10) // count columns

COLUMNS counts the number of columns in any supplied range and returns a number as a result. For example, if we provide all of row 1 in a range, Excel returns 16,384 the total number of columns in an Excel worksheet.

=COLUMNS(1:1) // returns 16384

To count rows in a range, see the ROWS function.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.