One way:

=SUMPRODUCT(--(A1:A102),--(A1:A10<10))

another

=COUNTIF(A1:A102) - COUNTIF(A1:A10<=10)

In article ,
"etan" wrote:

Hey there folks. I am wondering how to state the criteria in the COUNTIF
function to find values higher than one number and lower than another. Thank
you.