Thread
:
How do I count non blank rows only?
View Single Post
#
4
Posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
Posts: 22,906
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 With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben