Counting rows containing data (both numbers and text)

G

Guest

I've got numerous spreadsheets containing approx. 30K rows of data, with
blank rows used to seperate groups of data.

I need to count how many rows contain data, without counting the blank rows.

I think it's probably a COUNT IF function, but I'm not sure.

I'm not a very advanced user, so please be very specific in your reply.

Thank You
 
K

KL

I would say it shoud be COUNTA rather than COUNTIF. Try something like:

=COUNTA(A:A)

to count non-empty cells in the column [A]

Regards,
KL
 

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

counting data in columns with linked cells 4
Counting rows that meet multiple criteria 5
Counting Unique Values 27
Lookup vertically to next cell with data 2
COUNTIF, only counting once if both cells contain the data 4
counting data across worksheets 4
Conditional Formatting of numbers, but not text, in recurring rows 8
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1

Top