Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf formula
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf formula
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. -- 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf formula
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf formula
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF formula | Excel Worksheet Functions | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
CountIf formula help | Excel Discussion (Misc queries) | |||
countif formula | Excel Discussion (Misc queries) | |||
Countif formula and then some... | Excel Worksheet Functions |