| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of row entries
I have an excel file with entries in table format. I want excel to count how
many rows are in that information table. The 1st column of the table is an incrementing number. Maybe one way is for Excel to detect the presence of an entry in the cell & count the no. of cells which has an €˜x for example? Is this possible? Bob. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting number of row entries
You could use:
=counta(a:a) to count all the entries in column A. If you (always!) have headers in column A: =counta(A:a)-1 BobD wrote: I have an excel file with entries in table format. I want excel to count how many rows are in that information table. The 1st column of the table is an incrementing number. Maybe one way is for Excel to detect the presence of an entry in the cell & count the no. of cells which has an €˜x for example? Is this possible? Bob. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Counting number of items being added in a formula | Excel Discussion (Misc queries) | |||
| counting the number of printed spreadsheets | Excel Worksheet Functions | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
| Counting number of grades in a row | Excel Worksheet Functions | |||
Hybrid Mode
