Re: How can I count the number of entries in a column?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dave

=COUNTA(range) will return a count of all non-blank cells in the range.

=COUNT(range) will return just the numerical cells in the range.


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 08:17:09 -0800, "Dave Hacker" <Dave
Hacker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I wish to construct Auction Lists for my Philatelic Society. At present I
>make the list up in an Acces DB and then transfer it to Excel (2003). At
>this point I add extra columns to cater for "Bidders #'s"; "Selling price";
>"Price to Buyer";"Return to Vendor"; & "Return to Club", complete with
>relevant formulae. So far so good, I now wish to add, at the base of these
>columns, via a macro initially, a summary of data as entered. I also want to
>show, and use, in order to locate this data, the "TOTAL NUMBER OF LOTS".
>Simple, just count the "Lot #" column, no joy at all, and there doesn't
>appear to be an answer in the HELP files. Has any body any ideas.
>I could I suppose enter this number from the Access Database but would like
>to make it fully self-supporting.

.

Quantcast