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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count all rows in column with data, Except rows 1-5
=COUNTIF(Clients!A:A,"*")-COUNTIF(Clients!A1:A5,"*")
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gregory Day" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count all rows in column with data, Except rows 1-5
You could do it this way:
=COUNTIF(Clients!A:A,"*") - COUNTIF(Clients!A1:A5,"*") or like this: =COUNTIF(Clients!A6:A65536,"*") Hope this helps. Pete On Mar 27, 2:25*pm, Gregory Day wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count all rows in column with data, Except rows 1-5
=COUNTIF(Clients!A:A,"*")-COUNTIF(Clients!A1:A5,"*")
-- Gary''s Student - gsnu200776 "Gregory Day" wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count all rows in column with data, Except rows 1-5
You guys nailed it ! Thank you!
"Gregory Day" wrote: 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? |
Reply |
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) |