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

  • Thread starter Thread starter Gregory Day
  • Start date Start date
G

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?
 
=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)
 
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
 
Back
Top