Countif Statement

[denglish1584]

I am working with a spreadsheet of customer account numbers and a
wanting to get a total count of account numbers that ar

849835000000000 but <8498360000000000.

I attempted a countif statement but keep getting zero as a result.
Any guidance you have would be appreciated :

 

[Frank Kabel]

Hi
I'm not sure if you have added one zero too much in your second
condition. If this is not an error than this is not possible as the
second values consists of 16 significant digits and Excel only supports
15 digits.

But if this was an error try
=COUNTIF(A1:A100,">849835000000000")-COUNTIF(A1:A100>=849836000000000)

 

[denglish1584]

Thank you ~ Your input resolved my isseue :