How to count total columns in range in Excel

by on • 0 Comments

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 get relative row numbers in a range in Excel

Explanation

In the example, the active cell contains this formula:

=COLUMNS(B4:C9)

Tags:Cell Ranges & References COLUMNS function

← How to test a range for numbers in Excel

How to count total number of cells in a rectangular range in Excel →

Worked Examples

Excel Custom Number Format with Leading Zeros, Add Text, Colors Example
Highlight duplicate columns in Excel
VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
Get first text value with HLOOKUP in Excel
Vlookup Examples in Excel
DOLLAR function: Description, Usage, Syntax, Examples and Explanation
Extract multiple matches into separate rows in Excel

How to extract text between parentheses in Excel
Join cells with comma in Excel
Split dimensions into three parts in Excel
Extract most frequently occurring text in Excel
Basic outline numbering in Excel
How to Save your Excel files to OneDrive
Left Lookup in Excel
Remove line breaks in a cell in Excel
Highlight multiples of specific value in Excel
Lookup and sum column in Excel

Online Excel Courses Outline — Free

Excel For Beginners

*GETTING STARTED WITH EXCEL

Starting Excel Using Windows 7 (Or Previous Versions)
Selecting The Blank Worksheet Template
The Excel Cell Referencing System
Entering Numbers And Text
Default Text And Number Alignment
Summing A Column Of Numbers
Entering A Date
Worksheets And Workbooks
Saving A Workbook To Your Hard Disk
Closing A Workbook
Creating A New Workbook
Opening A Workbook
Switching Between Workbooks
Saving A Workbook Using Another Name
Saving A Workbook Using A Different File Type
Getting Help Within Excel
Searching For Online Help
Alt Key Help

*EXCEL SELECTION TECHNIQUES

Why Are Selection Techniques Important?
Selecting A Cell
Selecting A Range Of Connecting Cells
Selecting A Range Of Non-Connecting Cells
Selecting The Entire Worksheet
Selecting A Row
Selecting A Range Of Connecting Rows
Selecting A Range Of Non-Connected Rows
Selecting A Column
Selecting A Range Of Connecting Columns
Selecting A Range Of Non-Connecting Columns
Recommended Techniques When Creating Or Editing Lists

Find, Select, Replace and Go To Special in Excel

*MANIPULATING ROWS AND COLUMNS WITHIN EXCEL

Select, Insert, Rename, Move, Delete Worksheets in Excel
How to Delete Cells, Row and Rows in Excel
How to Insert Cells, Row and Rows in Excel

*MANIPULATING CELLS AND CELL CONTENT WITHIN EXCEL

How To Filter Data in Excel

*EXCEL WORKSHEETS

Switching Between Worksheets
Renaming A Worksheet
Recommended Techniques With Naming Worksheets
Inserting A New Worksheet
Deleting A Worksheet
Copying A Worksheet Within A Workbook
Moving A Worksheet Within A Workbook
Copying Or Moving Worksheets Between Workbooks

*FONT FORMATTING WITHIN EXCEL

Font Formatting Options
Font Type
Font Size
Bold, Italic, Underline Formatting
Cell Border Formatting
Formatting The Background Colour
Formatting The Font Colour

*ALIGNMENT FORMATTING WITHIN EXCEL

Alignment Options
Horizontally Aligning Contents In A Cell Range
Centering A Title Over A Cell Range
Cell Orientation
Text Wrapping Within A Cell
Aligning Cell Contents Vertically
Format Painter

*NUMBER FORMATTING WITHIN EXCEL

Number Formatting
- Format Cells and Numbers in Excel
Decimal Point Display
Applying And Removing Comma Style Formatting (To Indicate Thousands)
Currency Symbol
Date Styles
Percentages
Creating Formulas
The Easy Way To Create Formulas
Copying Formulas
Operators
Using Operators In Formulas
Formula Error Messages
Relative Cell Referencing Within Formulas
Absolute Cell Referencing Within Formulas

*EXCEL FUNCTIONS

What Are Functions?
Common Functions
Sum Function
Average Function
Max Function
Min Function
Count Function
The Counta Function
The Countblank Function
What Are ‘If Functions’?
Using The If Function

*EXCEL CHARTS

Inserting A Column Chart
Inserting A Line Chart
Inserting A Bar Chart
Inserting A Pie Chart
Resizing A Chart
Deleting A Chart

Miscellaneous

How to Create Gantt Chart in Excel
How to Create Area Chart in Excel
How To Create Pareto Chart in Excel
How to create a Histogram in Excel

*CHART TITLE OR LABELS

Changing The Column, Bar, Line Or Pie Slice Colours In A Chart
Modifying The Legend Fill Colour
Changing The Chart Type
Modifying Charts Using The Design Tab
Modifying The Chart Title
Modifying The Chart Axis
Modifying The Chart Legend
Modifying Chart Data Labels
Displaying Chart Data Tables
Modifying Chart Gridlines
Copying And Moving Charts Within A Worksheet
Copying And Moving Charts Between Worksheets
Copying And Moving Charts Between Workbooks

*CUSTOMISING EXCEL

Modifying Basic Excel Options

Customize Quick Access Toolbar in Excel
Add Developer Tab in Excel

Excel Intermediate

Have Fun Learning Microsoft Excel Level 2

Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.

*EXCEL SETUP & PRINTING ISSUES

Worksheet margins
Worksheet orientation
Worksheet page size
Headers and footers
Header and footer fields
Scaling your worksheet to fit a page(s)
Visually checking your calculations
Displaying gridlines when printing
Printing titles on every page when printing
Printing the Excel row and column headings
Spell checking
Previewing a worksheet
Viewing workbooks side by side
Zooming the view
Printing options
Setting the number of copies to print
Selecting a printer
Selecting individual worksheets or the entire workbook
Selecting which pages to print
Print Page Numbers in Excel
Single or double sided printing
Collation options
Clear print area in Excel Worksheet
Page orientation
Paper size
Margins
Scaling
Printing

*FUNCTIONS AND FORMULAS

Getting help with functions
Nested functions
Consolidating data using a 3-D reference sum function
Mixed references within formulas
- Relative, Absolute and Mixed Referencing Examples

*TIME & DATE FUNCTIONS

Inserting the current time and date
Today function
Now function
Day function
Month function
Year function

*MATHEMATICAL FUNCTIONS

Round function
Rounddown function
Roundup function

*LOGICAL FUNCTIONS

If function
And function
Or function

*MATHEMATICAL FUNCTIONS

Sumif function

*STATISTICAL FUNCTIONS

9 Mathematical Computations Example using Excel Statistical Function

Count function
Counta function
Countif function
Countblank function
Rank function

*TEXT FUNCTIONS

Left function
Right function
Mid function
Trim function
Concatenate function

*FINANCIAL FUNCTIONS

Fv function
Pv function
Npv function
Rate function
Pmt function

*LOOKUP FUNCTIONS

Vlookup function
- Lookup with variable sheet name in Excel
Hlookup function

*DATABASE FUNCTIONS

Dsum function
Dmin function
Dmax function
Dcount function
Daverage function

*EXCEL NAMED RANGES

Naming cell ranges
Removing a named range
Named cell ranges and functions

*EXCEL CELL FORMATTING

Applying styles to a range
Conditional formatting
Custom number formats
- Excel Custom Number Format with Leading Zeros, Add Text, Colors Example
- Advanced Number Formats in Excel

MANIPULATING WORKSHEETS WITHIN EXCEL

Copying or moving worksheets between workbooks
Splitting a window
Hiding rows
Hiding columns
Hiding worksheets
Un-hiding rows
Un-hiding columns
Un-hiding worksheets

EXCEL TEMPLATES

Using templates
Creating Excel templates
Editing Excel templates

PASTE SPECIAL OPTIONS WITHIN EXCEL

Using paste special to add, subtract, multiply & divide
Using paste special ‘values’
Using paste special transpose option

Excel Advanced

*PIVOT TABLES

Understanding Pivot Tables in Excel

Creating and using a pivot table
Filtering and sorting data within a pivot table
Automatically grouping data in a pivot table and renaming groups
Manually grouping data in a pivot table and renaming groups

*INPUT TABLES

One-input data tables
Two-input data tables

*CHARTS

Creating a combined line and column chart
Adding a secondary axis to a chart
Changing the chart type for a particular data series
Adding a data series to a chart
Removing a data series from a chart
Re-positioning chart title
Re-positioning the chart legend
Moving and formatting chart data labels
Modifying chart axis scales
Formatting an axis to display using commas
Inserting images into chart columns
Inserting images to chart bars
Formatting the chart plot area using a picture
Formatting the chart area using a picture

*HYPERLINKS

Inserting a hyperlink
Editing a hyperlink
Removing a hyperlink

*LINKING & EMBEDDING

What is embedding and linking?
Linking data within a worksheet
Linking cells between worksheets within a workbook
Linking data between workbooks
Linking data from Excel to a Word document
Linking an Excel chart to a Word document
Updating, locking and breaking links

*IMPORTING TEXT FILES

What is a delimited text file?
Importing a delimited text file

*SORTING AND FILTERING DATA

Sorting data by multiple columns at the same time
Applying a pre-installed custom sort
Creating a customized list and performing a custom sort
Removing a customised list
Using AutoFilter
Using AutoFilter to perform multiple queries
Top 10 AutoFilter
Removing all AutoFilters from a worksheet
Advanced filter criteria
Sub-totalling
Removing subtotals
Expanding and collapsing outline detail levels

*TRACKING AND REVIEWING CHANGES

Enabling or disabling the ‘track changes’ feature
Sharing, comparing and merging worksheets

*SCENARIOS

Scenario manager
Scenario summary reports

*VALIDATING

Prevent invalid data entering in specific cells Prevent invalid data entering in specific cells How To Create Drop-down List in Excel How to Create Dependent Drop-down Lists in Excel Prevent invalid Product Codes or ID Numbers in Excel Prevent Duplicate Entries in Excel Reject Invalid Dates in Excel Excel Data validation allow numbers only

Data validation – whole number
Data validation – decimal number
Data validation – list
Data validation – date
Data validation – time
Data validation – text length
Customising a validation input message and error alert
Removing data validation

*AUDITING

Tracing precedent cells
Tracing dependent cells
Identifying cells with missing dependents
Showing all formulas in a worksheet, rather than the resulting values
Inserting and viewing comments
Editing and deleting comments
Showing and hiding comments

*MACROS

Macro to change the page set-up
Macro to apply a custom number format
Macro to format a cell range
Macro to insert fields into the header or footer
Assigning a macro to a button on the quick access toolbar
Deleting macros

*PASSWORDS & SECURITY ISSUES

Steps To Password Protect a Workbook in Excel Protect and Unprotect Worksheet in Excel How to Protect and Unprotect Workbook in Excel Make Workbook Read-only in Excel

Adding ‘open’ password protection to a workbook
Adding ‘modify’ password protection to a workbook
Removing an ‘open’ password from a workbook
Removing a ‘modify’ password from a workbook
Password protecting cells and worksheets
Hiding formulas
Un-hiding formulas

Excel Office

How to count total columns in range in Excel

Formula

Explanation

Post navigation

Leave a Reply Cancel reply

Worked Examples

Online Excel Courses Outline — Free

*GETTING STARTED WITH EXCEL

*EXCEL SELECTION TECHNIQUES

*MANIPULATING ROWS AND COLUMNS WITHIN EXCEL

*MANIPULATING CELLS AND CELL CONTENT WITHIN EXCEL

*EXCEL WORKSHEETS

*FONT FORMATTING WITHIN EXCEL

*ALIGNMENT FORMATTING WITHIN EXCEL

*NUMBER FORMATTING WITHIN EXCEL

*EXCEL FUNCTIONS

*EXCEL CHARTS

Miscellaneous

*CHART TITLE OR LABELS

*CUSTOMISING EXCEL

Have Fun Learning Microsoft Excel Level 2

*EXCEL SETUP & PRINTING ISSUES

*FUNCTIONS AND FORMULAS

*TIME & DATE FUNCTIONS

*MATHEMATICAL FUNCTIONS

*LOGICAL FUNCTIONS

*MATHEMATICAL FUNCTIONS

*STATISTICAL FUNCTIONS

*TEXT FUNCTIONS

*FINANCIAL FUNCTIONS

*LOOKUP FUNCTIONS

*DATABASE FUNCTIONS

*EXCEL NAMED RANGES

*EXCEL CELL FORMATTING

MANIPULATING WORKSHEETS WITHIN EXCEL

EXCEL TEMPLATES

PASTE SPECIAL OPTIONS WITHIN EXCEL

*PIVOT TABLES

*INPUT TABLES

*CHARTS

*HYPERLINKS

*LINKING & EMBEDDING

*IMPORTING TEXT FILES

*SORTING AND FILTERING DATA

*TRACKING AND REVIEWING CHANGES

*SCENARIOS

*VALIDATING

*AUDITING

*MACROS

*PASSWORDS & SECURITY ISSUES