Forum Discussion
sterndavies
Mar 18, 2021Copper Contributor
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 ...
- Mar 18, 2021
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
sterndavies
Mar 18, 2021Copper Contributor
Thanks so much
tauqeeracma
Mar 18, 2021Iron Contributor
Your're welcome