Automatically include adjacent cells

[William...]

Hello,

I have the following formula: B1=COUNTA(A1:A5)-COUNTIF(A1:A5;"-"). I constantly add new entries to the range (A6,A7,A8.....). Every time I add an entry, Excel asks whether to update the formula to include the cell or not. Can I automate this process?

[Logit]

Try this:

B1=COUNTA(A1:A8)-COUNTIF(A1:A8;"-")

[Tony Valko]

Just expand the ranges in the formula...

=COUNTA(A1:A100)-COUNTIF(A1:A100;"-")

[William...]

Thanks both of you.

[Tony Valko]

You're welcome!

[Logit]

Thanks for the Add Rep.

Glad you got it worked out.