EXCEL: use SUMPRODUCT or COUNTIF?

خرید بک لینک

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

صفحه بندی