| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 "mconnolly" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
One way:
If every filled row has a value in column A: =COUNTA(A:A) In article , 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 |
|
#4
|
|||
|
|||
|
Try:
=counta(a1:a100) "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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
