Forum Discussion
Hello there!
Hello there! I'm currently beginner to excel and i have some problem of writing formula. The problem is i can't seem to find solution of finding how much number there are within the range of -1 and 0...
Anand_b_a Try this:
=COUNTIFS(B1:J1,"<=0",B1:J1,">=-1")
If this doesn't work, let us know what Excel version you are on and if you get any error message.
Another one would be:
=SUMPRODUCT((B1:J1<=0)*(B1:J1>=-1))
and should work in all Excel versions.