Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Contact
Home

 

 

Past Tip of the Day

 

Paul has a column of names. Is there a function which will count the number of text entries in the column?

Yes, Paul, this is frustrating. I will bet you are a recent Lotus 1-2-3 user. In Lotus, of course, @COUNT(A1:A100) would work, but alas in Excel, the COUNT() function only counts numeric entries. These small changes are one of the frustrating challenges in switching from Lotus to Excel. It would be so much easier if Microsoft were to include a help topic entitled, "Really Minor Changes we Made to the Most Popular @Functions."

The new function in Excel to count a column that contains text entries is
=COUNTA(A1:A100)

It's not a personal vendetta against former Lotus users - merely an effort to improve the product. You can now count everything with =COUNTA() or just count numeric data with =COUNT()....

Hey - by the way - if you are switching from Lotus, the @VLOOKUP has been improved - you will have to add a 4th argument of FALSE to get the Excel VLOOKUP to work like the Lotus @VLOOKUP.....

By Bill Jelen on 27-Oct-2001

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.