Forum Discussion
Solved
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) =COUN...
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.
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.
- Thanks! The typo is a silly error. I did change from text to numbers, but did it in "Format Cells" and it didn't take. Only Text to Column worked and allowed the formula to calculate correctly.
Much appreciated.
