text data - excluding rows

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?
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Cell data entering slow! 0
Need Help with a VBA subroutine 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Format column widths from one table to a separate table on same page 1
Weigh tasks 0
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Section and Page numbering 0

Top