text data - excluding rows

  • Thread starter Thread starter excelbeginner
  • Start date Start date
E

excelbeginner

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