M
Matt
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:A5>1,A1:A5<100),1,0))}
However I always get 0 for the answer. Any ideas?
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:A5>1,A1:A5<100),1,0))}
However I always get 0 for the answer. Any ideas?