Is the data in the column only text or is both text and numbers?

If it's text only:

=COUNTA(A1:A20,A50:A100)

If the data is both text and numbers:

=COUNTA(A1:A20,A50:A100)-COUNT(A1:A20,A50:A100)

--
Biff
Microsoft Excel MVP


"excelbeginner" wrote in message
...
Can I exclude rows when counting data in a column? Eg. can I count rows
1-20
and then 50-100 in the one function, or do I have to do it separately?