Both returned 0% when it should of returned 20%

"ShaneDevenshire" wrote:

Hi,

Or to continue using the -- approach

=SUMPRODUCT(--(M2:M10="b"),--(F2:F10<100)*(--(F2:F1050))/COUNTIF(M2:M10,"b"))

--
Thanks,
Shane Devenshire


"Rene" wrote:

How do I insert (F2:F1050) into the formula? Percentage of numbers between
50 and 100

SUMPRODUCT(--(M2:M10="b"),--(F2:F10<100))/COUNTIF(M2:M10,"b")

Thanks in advance.