countif formula needed
 

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

countif formula needed
 

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)

--
Biff
Microsoft Excel MVP


"dmdodds" wrote in message
...
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

countif formula needed
 

=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.

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"dmdodds" wrote in message
...
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

countif formula needed
 

Look again at the formula you were given, and correct yours accordingly.
Check the difference between , =, and <
--
David Biddulph

"dmdodds" wrote in message
...
=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.

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"dmdodds" wrote in message
...
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