View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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