View Single Post
  #1   Report Post  
mconnolly
 
Posts: n/a
Default Counting rows containing data (both numbers and text)

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