ExcelBanter - text data - excluding rows

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - text data - excluding rows (https://www.excelbanter.com/new-users-excel/197730-text-data-excluding-rows.html)

ExcelBeginner

text data - excluding rows

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?

T. Valko

text data - excluding rows

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?

All times are GMT +1. The time now is 05:51 AM.