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.