CountIf formula

  • Thread starter Thread starter Verne
  • Start date Start date
V

Verne

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
 
Try using p2:p26 and then insert a row after line 25 everytime.

Otherwise if the sheet is blank below the rows try p2:p2000.
 
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).
 
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.
 
Back
Top