A quick questioon about a formula. I search a method that will do this : it will check a column and if it meets a value, it should determine if this value is at least in one of two ranges (16-20 or 80-84) and it displays the number of values in these ranges once the column check is over.
For instance : if G1:G5 has (1,16,25,56,82), the formulas should send "2".
I'm currently using this formula but I don't know if it's optimal, if you have better alteative and/or if countif() could work / will be better :
=SUM(SUMPRODUCT((G$3:G$1000>15)*(G$3:G$1000<21)),SUMPRODUCT((G$3:G$1000>79)*(G$3:G$1000<85)))
Thanks a lot !
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 270
تاريخ: يکشنبه
10 مرداد
1395 ساعت: 0:57