countif formula needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to count the numbers in a range that fall equal to or more than one
number and equal to or less than one number
 
Try it like this:

=COUNTIF(A1:A10,">=start_number")-COUNTIF(A1:A10,">stop_number")

Start number = 10
Stop number = 20

=COUNTIF(A1:A10,">=10")-COUNTIF(A1:A10,">20")

Or, if you use cells to hold the start/stop numbers:

B1 = 10
B2 = 20

=COUNTIF(A1:A10,">="&B1)-COUNTIF(A1:A10,">"&B2)
 
=COUNTIF(A2:A37,">.7900")-COUNTIF(A2:A37,"<.7950")
This is what I tried and it is coming up with values that are not supposed
to be included, there should only be one entry that fits the formula with
these numbers.
 
Look again at the formula you were given, and correct yours accordingly.
Check the difference between >, >=, and <
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Excel Excel 2007 Formula Help Needed 1
COUNTIFS 2
"If" Formula Error 3
Escel: Count students >=20 and <=29 1
Counting Problem 2
COUNTIF Cells in Range? 4

Back
Top