Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif
want to use countif and conditional formatting. can you use a variable in
countif? e.g. say break point is $x.xx and i change, i want the conditional formatting to change, no problem, but the countif does not change with the variable value w/o re-entering all. any ideas |
#2
|
|||
|
|||
Hi reno
not sure exactly what you're saying here, if you're using a formula such as =COUNTIF(A1:A10,50) then you need to change the 50 to 55 if that's what you now want to count, alternatively you can reference a cell in the countif function =COUNTIF(A1:A10,B1) and then the countif will update if the value in B1 changes as long as the calculation mode is set to automatic (tools / options / calculation - ensure automatic is selected). hope this helps Cheers JulieD "reno" wrote in message ... want to use countif and conditional formatting. can you use a variable in countif? e.g. say break point is $x.xx and i change, i want the conditional formatting to change, no problem, but the countif does not change with the variable value w/o re-entering all. any ideas |
#3
|
|||
|
|||
thx, this will work, but wanted to use a named variable
"JulieD" wrote: Hi reno not sure exactly what you're saying here, if you're using a formula such as =COUNTIF(A1:A10,50) then you need to change the 50 to 55 if that's what you now want to count, alternatively you can reference a cell in the countif function =COUNTIF(A1:A10,B1) and then the countif will update if the value in B1 changes as long as the calculation mode is set to automatic (tools / options / calculation - ensure automatic is selected). hope this helps Cheers JulieD "reno" wrote in message ... want to use countif and conditional formatting. can you use a variable in countif? e.g. say break point is $x.xx and i change, i want the conditional formatting to change, no problem, but the countif does not change with the variable value w/o re-entering all. any ideas |
#4
|
|||
|
|||
Hi reno
if i use insert / name / define and create a variable called "const" and assign the number 5 to it (in refers to) then using =COUNIF(A1:A10,const) returns the number of 5's in the range, if i then change the refers to to 10, it returns the number of 10s in the range ... what's different for you Cheers JulieD "reno" wrote in message ... thx, this will work, but wanted to use a named variable "JulieD" wrote: Hi reno not sure exactly what you're saying here, if you're using a formula such as =COUNTIF(A1:A10,50) then you need to change the 50 to 55 if that's what you now want to count, alternatively you can reference a cell in the countif function =COUNTIF(A1:A10,B1) and then the countif will update if the value in B1 changes as long as the calculation mode is set to automatic (tools / options / calculation - ensure automatic is selected). hope this helps Cheers JulieD "reno" wrote in message ... want to use countif and conditional formatting. can you use a variable in countif? e.g. say break point is $x.xx and i change, i want the conditional formatting to change, no problem, but the countif does not change with the variable value w/o re-entering all. any ideas |
#5
|
|||
|
|||
JuileD, thanks, i must have used a reserved word as the variable name, this
seems to work fine now, thought it would. thx "JulieD" wrote: Hi reno if i use insert / name / define and create a variable called "const" and assign the number 5 to it (in refers to) then using =COUNIF(A1:A10,const) returns the number of 5's in the range, if i then change the refers to to 10, it returns the number of 10s in the range ... what's different for you Cheers JulieD "reno" wrote in message ... thx, this will work, but wanted to use a named variable "JulieD" wrote: Hi reno not sure exactly what you're saying here, if you're using a formula such as =COUNTIF(A1:A10,50) then you need to change the 50 to 55 if that's what you now want to count, alternatively you can reference a cell in the countif function =COUNTIF(A1:A10,B1) and then the countif will update if the value in B1 changes as long as the calculation mode is set to automatic (tools / options / calculation - ensure automatic is selected). hope this helps Cheers JulieD "reno" wrote in message ... want to use countif and conditional formatting. can you use a variable in countif? e.g. say break point is $x.xx and i change, i want the conditional formatting to change, no problem, but the countif does not change with the variable value w/o re-entering all. any ideas |
#6
|
|||
|
|||
Hi reno
you're welcome and thanks for the feedback. Cheers JulieD "reno" wrote in message ... JuileD, thanks, i must have used a reserved word as the variable name, this seems to work fine now, thought it would. thx "JulieD" wrote: Hi reno if i use insert / name / define and create a variable called "const" and assign the number 5 to it (in refers to) then using =COUNIF(A1:A10,const) returns the number of 5's in the range, if i then change the refers to to 10, it returns the number of 10s in the range ... what's different for you Cheers JulieD "reno" wrote in message ... thx, this will work, but wanted to use a named variable "JulieD" wrote: Hi reno not sure exactly what you're saying here, if you're using a formula such as =COUNTIF(A1:A10,50) then you need to change the 50 to 55 if that's what you now want to count, alternatively you can reference a cell in the countif function =COUNTIF(A1:A10,B1) and then the countif will update if the value in B1 changes as long as the calculation mode is set to automatic (tools / options / calculation - ensure automatic is selected). hope this helps Cheers JulieD "reno" wrote in message ... want to use countif and conditional formatting. can you use a variable in countif? e.g. say break point is $x.xx and i change, i want the conditional formatting to change, no problem, but the countif does not change with the variable value w/o re-entering all. any ideas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Countif, Sumif, If - help! | Excel Worksheet Functions | |||
variable range countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |