Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of Lines in a Worksheet Function?
I have an Excel file with four worksheets. In each worksheet is a
list of computer names which can total 1,000 per worksheet. I want to create a new worksheet that lists just four numbers: the total number of computers/lines in each worksheet. Is that something I can do with a function? I'm hoping that as each worksheet gets updated, the "report" worksheet will automatically update its numbers with the new totals in the other four worksheets. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of Lines in a Worksheet Function?
Use the CountA function
=COUNTA(Sheet1!A:A) =COUNTA(Sheet2!A:A)... This will return the count of cells with non-null values in column a of sheet 1, sheet 2, etc. If you add or delete a value, this formula will automatically reflect the new count. Of course you will have to pick a column which always has a value for each machine in your list. -----Original Message----- I have an Excel file with four worksheets. In each worksheet is a list of computer names which can total 1,000 per worksheet. I want to create a new worksheet that lists just four numbers: the total number of computers/lines in each worksheet. Is that something I can do with a function? I'm hoping that as each worksheet gets updated, the "report" worksheet will automatically update its numbers with the new totals in the other four worksheets. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number of Lines in a Worksheet Function?
That was it! Thanks!
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extending the number of lines in a worksheet | Excel Discussion (Misc queries) | |||
Extending the number of lines in a worksheet | Excel Discussion (Misc queries) | |||
Extending the number of lines in a worksheet | Excel Discussion (Misc queries) | |||
Worksheet function to refer to columns by number | Excel Discussion (Misc queries) | |||
Does the Wrap function in excel allow a maximum number of lines? | Excel Discussion (Misc queries) |