How do I count non blank rows only?

  • Thread starter Thread starter Susan Mc
  • Start date Start date
S

Susan Mc

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(G69>0,(=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
 
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
 
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
 
Back
Top