ADVERTISEMENT
the problem as written, the answer I get is zero when there are at least 150 cells
in col AZ that meet meet the criteria. All cols are formatted number
=COUNTIFS(AZ30:AZ999, ">=0.01", AZ30:AZ999, "<=9.99")
=COUNTIF(AZ30:AZ999, {">=0.01","<=9.99"})
=SUMPRODUCT(--(ISNUMBER(MATCH(ROW($A$1:$A$999)/100,AZ30:AZ999,0))))