IF one to four numbers fall within a range

[sans]

Hello,

I have a list of 5 numbers and I would like to get a checkmark when 1 to 4 numbers fall within a range of 1 to 4. For example,

5-5-3-9-6 - This will get a checkmark because 1 number falls within 1 to 4
1-3-4-4-2 - No checkmark as 5 numbers fall within 1 to 4 and the max is 4
7-4-4-3-14 - Checkmark because 3 numbers fall within 1 to 4
16-8-9-1-1 - Checkmark because 2 numbers fall within 1 to 4
18-5-7-10-5 - No checkmark because no numbers for within 1 to 4 and the minimum is 1

I have tried an IF AND statement but I cant figure out how to also apply the condition that if 1 to 4 numbers are within a range to get the checkmark.

Thank you
Sans

[NBVC]

I am curious to why these sudden and rapid variations in requests over the last few days... is this homework?

[NBVC]

In the meantime, assuming range starts in C2:G2, then in H2:

=IF(AND(COUNTIF(C2:G2,"<=4")>0,COUNTIF(C2:G2,"<=4")<=4),CHAR(252),CHAR(251))

copied down

Change font to Wingdings.

[sans]

Haha, thank you so much for helping me, I 'm working on mathematical statistics.
It works great! I have tried changing the criteria, for instance, when 2 to 4 numbers fall within a range of 3 to 5 but I keep getting errors. Do I have to change only the numbers or also something else to make it work?
Again, thank you very much for your time and help! Sans

[NBVC]

Assuming you have Excel 2003 like your profile states, then you need to use SUMPRODUCT() instead of COUNTIF() to test 2 conditions....

so try:

=IF(AND(SUMPRODUCT(--(C2:G2>=3),--(C2:G2<=5))>=2,SUMPRODUCT(--(C2:G2>=3),--(C2:G2<=5))<=4),CHAR(252),CHAR(251))

[sans]

Hi NBVC,
Thank you very very much for your help. The formula works great! Exactly what I was looking for. I am working with excel 2010, sorry about that just updated today my profile. Again , thank you.