If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I count the number of entries in a column?
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. |
#3
|
|||
|
|||
How can I count the number of entries in a column?
Gord: The point is that theoretically I do not know the range. Is there a
way I can return the first blank row number as a result, this could then be manipulated "Gord Dibben" wrote: 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 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. |
#4
|
|||
|
|||
How can I count the number of entries in a column?
Dave,
As you have only one group of data, you can use a whole column as the range, since COUNTA counts non-blank cells, like so =COUNTA(A:A). It might be 1 or 2 too many for headings , if so just subtract that number in the formula. -- HTH RP (remove nothere from the email address if mailing direct) "Dave Hacker" wrote in message ... Gord: The point is that theoretically I do not know the range. Is there a way I can return the first blank row number as a result, this could then be manipulated "Gord Dibben" wrote: 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 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help to append flat file table to two tables | Victoriya F via AccessMonster.com | Running & Setting Up Queries | 11 | September 26th, 2005 05:30 PM |
Return Count for LAST NonBlank Cell in each Row | Sam via OfficeKB.com | Worksheet Functions | 12 | April 17th, 2005 10:36 PM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
Count number of occurances in column | acorbally | Worksheet Functions | 4 | May 3rd, 2004 07:26 PM |
count number of times a word appears in a column | Tushar Mehta | Charts and Charting | 0 | November 15th, 2003 12:23 AM |