Countif large values

[Joe C]

I have a large 18 digit number. Does countif have alimit on the numbers of characters a number can have before it views it the same?

 

[Aladin Akyurek]

The number precision is 15 digits. A 18-digit number would be a text number.

 

[Joe C]

Thank you. That is not the case for Vlookup?

Is it the case for Sumif.

So if I want to use countif I would need to change the first digit to a letter. It is always the same.

 

[Scott Huish]

Excel can not display a number with more than 15 significant digits as the number. If you are showing 18 digits then it is text. It has nothing to do with the function you're using, it is a limitation of Excel in general.

If you want to do a COUNTIF on these values, and are using a literal value, specify the number as text:

=COUNTIF(A:A,"123456789012345678")