Countif Statement

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 :
 
F

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple arguments 3
Page numbering with Merged Document and IF statements 1
Using <= in countifs statement 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Finding the weighted average of text that have been given values 1
Need countifs forumla to analize in a time range 2
Conditional Formatting based on active Named Range; IF Function to VBA 1
countifs Function not giving desired result with date criteria 2

Top