Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I count non blank rows only?
This seems so simple but I've spent hours without resolution. In column A,
I need to count the number of rows that actually have data in them. If there is no data, I need to keep column A blank. Here's an oversimplied example of my simple list. 1 John Doe 2 Susan Smith 3 Joe Dear In column A now I have =COUNTA($B$2:B64) and that works great until you hit a row with no data. I have tried all these: =IF(G690,(=COUNTA($B$2:B69))," ") Also =COUNTIF($B$2:B69,"0") There's got to be an easy way that I'm missing!! HEEEELP please. Thank you, Susan |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I count non blank rows only?
=COUNTA(B:B)
will count all the non-empty entries in column B -- Gary''s Student - gsnu200793 "Susan Mc" wrote: This seems so simple but I've spent hours without resolution. In column A, I need to count the number of rows that actually have data in them. If there is no data, I need to keep column A blank. Here's an oversimplied example of my simple list. 1 John Doe 2 Susan Smith 3 Joe Dear In column A now I have =COUNTA($B$2:B64) and that works great until you hit a row with no data. I have tried all these: =IF(G690,(=COUNTA($B$2:B69))," ") Also =COUNTIF($B$2:B69,"0") There's got to be an easy way that I'm missing!! HEEEELP please. Thank you, Susan |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I count non blank rows only?
Hi Susan,
Not sure but it sounds like you need something to put in A2 and drag down. Maybe this =IF(B2="","",COUNTA(B$2:B2)) HTH Martin "Susan Mc" <Susan wrote in message ... This seems so simple but I've spent hours without resolution. In column A, I need to count the number of rows that actually have data in them. If there is no data, I need to keep column A blank. Here's an oversimplied example of my simple list. 1 John Doe 2 Susan Smith 3 Joe Dear In column A now I have =COUNTA($B$2:B64) and that works great until you hit a row with no data. I have tried all these: =IF(G690,(=COUNTA($B$2:B69))," ") Also =COUNTIF($B$2:B69,"0") There's got to be an easy way that I'm missing!! HEEEELP please. Thank you, Susan |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I count non blank rows only?
COUNTA will count only non-blank cells.
What are you trying achieve with your formula(s) in column A? Where does G69 come into play? Maybe =IF(B2="","",COUNTA($B$2:B64)) Entered in A2 and copied down? Gord Dibben MS Excel MVP On Sun, 22 Jun 2008 06:30:01 -0700, Susan Mc <Susan wrote: This seems so simple but I've spent hours without resolution. In column A, I need to count the number of rows that actually have data in them. If there is no data, I need to keep column A blank. Here's an oversimplied example of my simple list. 1 John Doe 2 Susan Smith 3 Joe Dear In column A now I have =COUNTA($B$2:B64) and that works great until you hit a row with no data. I have tried all these: =IF(G690,(=COUNTA($B$2:B69))," ") Also =COUNTIF($B$2:B69,"0") There's got to be an easy way that I'm missing!! HEEEELP please. Thank you, Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count from Blank & Non-Blank Cells | Excel Discussion (Misc queries) | |||
How do I delete blank rows (rows alternate data, blank, data, etc | Excel Discussion (Misc queries) | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
How to count blank cells (Rows) between Non-Blank cells in Col "A" | Excel Discussion (Misc queries) | |||
Count Non-Blank Rows | Excel Worksheet Functions |