Forum Discussion
Solved
COUNTIF counts wrong
Hi, I found a problem using COUNTIF function, when trying count data as shown below: Excel says that there is 7 matches. Looks like it cut last three digits for counting (this is only sample, but it...
Excel uses only 15 digits. Any additional digit will be changed to 0.
You could format the values as text but unfortunately COUNTIF() does a type conversion (text to number).
For more information and a solution click here:
https://newtonexcelbach.com/2017/12/22/the-countif-bug-and-how-to-avoid-it/
Excel uses only 15 digits. Any additional digit will be changed to 0.
You could format the values as text but unfortunately COUNTIF() does a type conversion (text to number).
For more information and a solution click here:
https://newtonexcelbach.com/2017/12/22/the-countif-bug-and-how-to-avoid-it/