Use the COUNTA() function, i.e.,
=COUNTA(A1:A30000)
"mconnolly" wrote:
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
|