Forum Discussion
Solved
COUNTIF Not Working
If anyone could help me i'd appreciate it so much. For whatever reason, this formula is not picking up the "number" formatted numbers in the column with this spreadsheet. The formula is suppose to ...
Instead of countif() you may use countifs() function that allows to give multiple creteria as mentions below:
=COUNTIFS(D6:D15,">.5",D6:D15,"<1.49")
Thanks
Hello
If i do >= this will count everything higher than 2 as well which is not what i am looking for. I am looking for a function that will count everything that is =2 or =1 only if that makes sense.
is there a way to do countif >= .5 and <=1.49 as one formula? Since the rounded numbers aren't being picked up?
If i do >= this will count everything higher than 2 as well which is not what i am looking for. I am looking for a function that will count everything that is =2 or =1 only if that makes sense.
is there a way to do countif >= .5 and <=1.49 as one formula? Since the rounded numbers aren't being picked up?
Instead of countif() you may use countifs() function that allows to give multiple creteria as mentions below:
=COUNTIFS(D6:D15,">.5",D6:D15,"<1.49")
Thanks
- Thanks so much
- Your're welcome