It works for me if I enter numbers in Column B. However, if I enter letters
or letters or numbers, then I need to use a 3 as the first argument to
Subtotal.

IF(B2<"",SUBTOTAL(3,$B$2:B2),"")

--
Regards,
Tom Ogilvy

"StargateFan" wrote in message
...
On Thu, 06 Oct 2005 00:24:32 -0400, StargateFan
wrote:

On Mon, 14 Jun 2004 19:46:56 -0400, StargateFan
wrote:

On Mon, 14 Jun 2004 16:19:53 -0400, "Bernie Deitrick" <deitbe @
consumer dot org wrote:

Stargate,

=IF(B2<"",SUBTOTAL(2,$B$2:B2),"")

[snip]

I tried to use this type of thing in this situation but must admit
that I don't have a clue on integrating the formula
=SUBTOTAL(2,$B$2:B2) with an if statement of this kind. If you
know
how, can you pls advise?

[snip]

This formula has always worked befo

=IF(B2<"",SUBTOTAL(2,$B$2:B2),"")

But lately since I've been using it, I get all "0" in the column and
no numbers. The new spreadsheets where I've been trying to
incorporate this are no different from the original spreadsheets where
I used this formula.

What the above does, btw, is number the rows 1, 2, 3, etc. But the
trick is that even when filtered, the numbering is reflected correctly
because of this formula.

Column A holds the above formula and the IF statement means that the
cell in column A is blank until a value is put in the cell to the
right of it.

Hopefully someone knows why this is no longer working. Thanks! :oD