#1   Report Post  
reno
 
Posts: n/a
Default 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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
reno
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
reno
 
Posts: n/a
Default

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   Report Post  
JulieD
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal And Countif Sheryl Excel Discussion (Misc queries) 4 December 9th 04 08:18 PM
Countif, Sumif, If - help! Angel160 Excel Worksheet Functions 2 November 3rd 04 06:23 PM
variable range countif JK Excel Worksheet Functions 3 November 3rd 04 08:50 AM
countif, again Liz G Excel Worksheet Functions 2 November 2nd 04 12:20 AM
combining countif formulas Liz G Excel Worksheet Functions 3 November 1st 04 10:34 PM


All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"