Forum Discussion
COUNTIF and COUNTIFS giving different results
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
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.
6 Replies
Could you attach a sample workbook demonstrating the problem? Don't include any sensitive information.
Yes please see attached file. Thanks
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.
