Using >= in cell as part of formula (1 Viewer)

KenHigg

Registered User
Local time
Today, 09:53
Joined
Jun 9, 2004
Messages
13,327
Hi all, long time since I've been here.
Anyway, I have a countif() where the if refs a cell that contains <=250. It all works but now I would like to make the 250 dynamic, like maybe it comes from a slider bar, etc. Any suggestions?
Here is the countif(): '=COUNTIFS($B$18:$B$3007,$K$2,$C$18:$C$3007,$L2)'. L2 is contains the '<=250'.
Thanks
Ken
 

Minty

AWF VIP
Local time
Today, 13:53
Joined
Jul 26, 2013
Messages
10,354
Wouldn't you need it to be

COUNTIFS($B$18:$B$3007,$K$2,$C$18:$C$3007,<=$L2)

And put 250 in $L2
Assuming you aren't trying to change the <= expression?
 

KenHigg

Registered User
Local time
Today, 09:53
Joined
Jun 9, 2004
Messages
13,327
I'll try that - thanks

Edit = actually got it to work this way as well: =">="&M2 where I adjust the val in m2
 

Isaac

Lifelong Learner
Local time
Today, 06:53
Joined
Mar 14, 2017
Messages
8,738
You could keep the cell reference, and put an ActiveX sheet control there to allow the user to manipulate that cell - same effect, basically.
(although I'm not necessarily opining on whether the slider bar is any better for the user than typing 250 in a cell)
 

KenHigg

Registered User
Local time
Today, 09:53
Joined
Jun 9, 2004
Messages
13,327
Probably right about better / worse but the slider is a. used to put a value in a field then it spawns values in several other fields which makes it a tad better than typing all the values in and, b. kind of sucks the user in watching a graph dynamically change as you slide it up and down... :)
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:53
Joined
May 7, 2009
Messages
19,169
sample dynamic criteria using slider.
 

Attachments

  • countIfs.zip
    16.4 KB · Views: 143

Gasman

Enthusiastic Amateur
Local time
Today, 13:53
Joined
Sep 21, 2011
Messages
14,042
Probably right about better / worse but the slider is a. used to put a value in a field then it spawns values in several other fields which makes it a tad better than typing all the values in and, b. kind of sucks the user in watching a graph dynamically change as you slide it up and down... :)
Which could still be done when typing in a single value surely? :unsure:
 

Users who are viewing this thread

Top Bottom