Wow- That's really A-Level. Thanks.

"Dave Peterson" wrote:

One way:
=COUNTIF(A1:A30,"<10")-COUNTIF(A1:A30,"<=5")
and another:
=SUMPRODUCT(--(A1:A305),--(A1:A30<10))

=sumproduct() likes to work with numbers. The -- stuff changes trues to 1's and
falses to 0's.