Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
How do I count the number of cells in a column in excel that begi. | Excel Discussion (Misc queries) | |||
Count number of unique items in a column that contains duplicates | Excel Worksheet Functions |