Aug 12 2021 08:08 AM
Windows10Pro and Microsoft 365 Apps for Business. Excel Ver 2107.
COUNTIF in one formula does not counts any of the cells, while the same formula on another column gives the correct answer: 1) =COUNTIF(C3:C282,"<60") 2) =COUNTIF(F3:F282,">4")
I changed the numbers from General to Number and get same result. Same issue with COUNTIFS.
Thanks
Aug 12 2021 08:10 AM
Could you attach a sample workbook demonstrating the problem? Don't include any sensitive information.
Aug 12 2021 08:27 AM
Yes please see attached file. Thanks
Aug 12 2021 08:48 AM
Solution@PhilipLibman First of all, the "numbers" in column A and B were texts. Fixed that with Text-to-columns. Then, the second formula contains a typo. You used COUINTIF. Hence the #NAME? error. Remove the letter "I" marked in red and it shall work.
See attached.
Aug 12 2021 09:03 AM
Aug 12 2021 09:11 AM
@PhilipLibman You're welcome. And just bare in mind that formatting a cell as Number doesn't change the content of the cell to a number if it had been entered/imported as a text.
Aug 12 2021 11:34 AM
You learn something new every day! Thanks again.
Aug 12 2021 08:48 AM
Solution@PhilipLibman First of all, the "numbers" in column A and B were texts. Fixed that with Text-to-columns. Then, the second formula contains a typo. You used COUINTIF. Hence the #NAME? error. Remove the letter "I" marked in red and it shall work.
See attached.