Referencing a cell (range instead of 1 number)

I have a working formula that references a cell. That cell can have one number in it or greater than a number or less than. (I.E. for all data points greater than 1 is just >1 in that cell)

Is there a way to set a range instead of one number. I.E. include all data point that are between 2 and 4?

Thanks

So my formula is a countifs, and one of the stipulations is a reference to a cell. In that cell I can either input one of the numbers that appear in the range of cells mentioned or I can input a greater than or less than sign before a number. All of these work perfectly. What I'm wondering is if it's possible to instead of just have 1 number, or just greater than one number or less than one number, i have a range of numbers, like 2 to 4 instead of 2 or >2 or <4.

Perfect. Thanks!