Mar 18 2021 11:20 AM
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 tell how many have the "1" and "2" value in the column. However, it's showing 0 for both but there should be values being picked up.
Thank you!
Mar 18 2021 11:39 AM
Hi
All of the data in column B has decimal places wheras you are comparing rounded numbers that is why no data is being picked up.
You may use '>' or '<' sign as per your requirement. for example
=COUNTIF(B2:B65,">=2")
Thanks
Tauqeer
Mar 18 2021 11:47 AM
Mar 18 2021 11:52 AM
SolutionInstead 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
Mar 18 2021 11:52 AM
SolutionInstead 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