Countif Statement

  • Thread starter Thread starter denglish1584
  • Start date Start date
D

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.
Click to expand...
I attempted a countif statement but keep getting zero as a result.
Any guidance you have would be appreciated :
 
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)
 
Back
Top