| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count all rows in column with data, Except rows 1-5
I would like to count all of the rows in Column A that contain any text,
except Rows 1 through 5. I have the following formula, which worked, but included rows 1-5. =COUNTIF(Clients!A:A,"*") I then tried this, which didnt' work. =COUNTIF(Clients!A3:A*,"*") How can I make it counts all rows, below 5 with data in column A? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count rows in a column for looping | Excel Discussion (Misc queries) | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| Count the number of rows where more than one column meets set crit | Excel Worksheet Functions | |||
| Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
| Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
Threaded Mode
