<div>
Do you mean the no of columns with data?<br />
<br />
If you don't then you can just use COLUMNS which will return the no of columns in a range.
</div>


Do you mean the no of columns with data?

If you don't then you can just use COLUMNS which will return the no of columns in a range.

<div>
Thanks for the grade....<br />
<br />
Just a note on that first formula you listed<br />
<br />
=COUNTA($A$1:$D$1)+COUNTBL<wbr />ANK($A$1:$<wbr />D$1)<br />
<br />
You have to be careful with that if any of the cells contains &quot;formula blanks&quot; (null strings) as both COUNTA and COUNTBLANK count those....so it's possible that that formula could give you a result of 4,5,6,7 or 8!<br />
<br />
regards, barry
</div>


Thanks for the grade....

Just a note on that first formula you listed

=COUNTA($A$1:$D$1)+COUNTBLANK($A$1:$D$1)

You have to be careful with that if any of the cells contains "formula blanks" (null strings) as both COUNTA and COUNTBLANK count those....so it's possible that that formula could give you a result of 4,5,6,7 or 8!

regards, barry

<div>
<div class="content wysiwyg-content">
I need an efficient and preferably non-volatile worksheet function to count the columns in a supplied range. &nbsp;I am using e.g.
<pre><code id="code-10-27385505-1">=COUNTA($A$1:$D$1)+COUNTBLANK($A$1:$D$1)</code></pre>
 for a range that has only one row, or I guess I could have 
<pre><code id="code-10-27385505-2">=COUNTA(INDEX($A$1:$E$22,1,))+COUNTBLANK(INDEX($A$1:$E$22,1,))</code></pre>
 for a range with multiple rows.<br />
<br />
Obviously I could have a simple UDF like 
<pre><code id="code-10-27385505-3">Public Function ColCount(ByRef rngIn As Excel.Range) As Long
    ColCount = rngIn.Columns.Count
End Function</code></pre>
to do this, but I'm looking for a worksheet function if possible.<br />
<br />
Any better ideas than mine?
</div>
</div>


I need an efficient and preferably non-volatile worksheet function to count the columns in a supplied range.  I am using e.g.(CODE) for a range that has only one row, or I guess I could have (CODE) for a range with multiple rows.

Obviously I could have a simple UDF like (CODE)to do this, but I'm looking for a worksheet function if possible.

Any better ideas than mine?

Excel count columns in a range

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.