Excel 2007 : Counting non-blank cells

[Sailorjohn]

Hey all,

Hope this is possible. I am trying to count non-blank cells in column D and number the rows with information concecutively.

1. Smith
2. Jones
3. Brown
4. Barnes
BLANK
BLANK
5. Kinley

I've tried everything I know, I've googles every combination of words that could help. I found one formula that 'kinda' worked, but it counted cells with the same data in them together, and to be honest, I can't remember what the formula was!

Hope yall can help!

[zbor]

Here, try this:

=COUNTA(D:D)

[Sailorjohn]

Here, try this:

=COUNTA(D:D)

That's the formula I tried last time. It works, except I have to manually change the formula (IE: going from =COUNTA(D5:D6) to =COUNTA(D5:D7) for 300 lines. Even worse, it will leave the previous value if its counting a blank row. I need consecutive numbers for non-blank, and nothing for blank.

Thanks for the response though!

[zbor]

Can you write how do you want that your output looks like?

[Sailorjohn]

Can you write how do you want that your output looks like?

1 Smith
2 Jones
2
3 Williams
4 Brown

and Im trying to get-

1 Smith
2 Jones

3 Williams
4 Brown


Thanks again!

[zbor]

And in first column is formula?

Then use:

=IF(ISTEXT(B1), COUNTIF($B$1:B1 "?*"), "")

This will ignore numbers in B column if you have any...
IF you don't you can use:

=IF(ISTEXT(B1), COUNTA($B$1:B1), "")