=SUMPRODUCT((A1:A100>10)*(A1:A100