How to count total columns in range in Excel

by
If you need to count the number of columns in a range, use the COLUMNS function.
COLUMNS counts the number of columns in and returns the result as a number.

Formula

=COLUMNS(range)

Worked Example:   How to use Excel COLUMNS Function
Worked Example:   How to work on another Workbook in Excel -- External References

Explanation

In the example, the active cell contains this formula:

=COLUMNS(B4:C9)
Worked Example:   Check if range contains a value not in another range in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *