=SUM(IF((A1:A51)*(A1:A5<10),1))

ctrl+shift+enter, not just enter


"Matt" wrote:

Say if have a list of numbers in cells A1:A5

12
99
9
3
60

I would like to count the number of values that are between 1 and 10
exclusive using a formula something like this:

{=SUM(IF(AND(A1:A51,A1:A5<100),1,0))}

However I always get 0 for the answer. Any ideas?