Count all rows in column with data, Except rows 1-5

[Gregory Day]

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?

 

[Bob Phillips]

=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)

 

[Pete_UK]

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

 

[Gary''s Student]

=COUNTIF(Clients!A:A,"*")-COUNTIF(Clients!A1:A5,"*")

 

[Gregory Day]

You guys nailed it ! Thank you!