count with and formula
Dear all;
I am trying to use countif with and like this.
COUNTIF(A1:A12,and("30","<100"))
I did try it with diffrent condition and even replace and with or but it
just show me answer 0.
is there any other way to use countif with multiple conditions?
|