Using >= in cell as part of formula

[KenHigg]

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]

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]

I'll try that - thanks

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

 

[Isaac]

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]

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]

sample dynamic criteria using slider.

 

[Gasman]

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?

 

[Isaac]

This thread just reminded me of a really funny article I read, read all the way through, you'll get a good laugh for the day!

Programmers imagine the most ridiculous ways to enter a phone number into a form — Quartz (qz.com)