CountIf formula

I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included. Right now, I have to add the row to the formula manaually. Thank
you for your help.

Hi

Just enlarge the range to as many rows as you think you will need:

=COUNTIF(P2:P1000,"x")

Regards,
Per

"Verne" skrev i meddelelsen
...
I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included. Right now, I have to add the row to the formula manaually. Thank
you for your help.

Try using p226 and then insert a row after line 25 everytime.

Otherwise if the sheet is blank below the rows try p22000.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Verne" wrote:

I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included. Right now, I have to add the row to the formula manaually. Thank
you for your help.

Try this:
=COUNTIF(P:P,"x")
this will work with COUNTIF() and some other functions, but not all.

Of course the catch here is that if there's an "x" in row 1, or if there are
entries below your current range of row 25 that are x's and you don't want
them counted, you can't use it as is. Another catch is that the formula
can't be in column P either (creates a circular reference error).

"Verne" wrote:

I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included. Right now, I have to add the row to the formula manaually. Thank
you for your help.

you can try this:
always include a blank row in your formula
say currently your data is from row 2 to row 25, instead of using
=COUNTIF(P2:P25,"x"), use =COUNTIF(P2:P26,"x"), row 26 being the blank row.
next time you insert a new row, do it on row 26 (ie right click row 26,
choose insert), this will insert a new row between 25 and 26, so the new row
could be included in the formula.
--
====================
ask and you shall be answered


"JLatham" wrote:

Try this:
=COUNTIF(P:P,"x")
this will work with COUNTIF() and some other functions, but not all.

Of course the catch here is that if there's an "x" in row 1, or if there are
entries below your current range of row 25 that are x's and you don't want
them counted, you can't use it as is. Another catch is that the formula
can't be in column P either (creates a circular reference error).

"Verne" wrote:

I am using a count if formula =COUNTIF(P2:P25,"x") - everytime I add a new
row, that row is not included in the formula. What can I do so it is
included. Right now, I have to add the row to the formula manaually. Thank
you for your help.