View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default CountIf Function

Use countif twice, once to count those that are =5 and a second time to
count those that are 10. The difference is the count of those in the range
[5,10]:
=countif(range,"=5")-countif(range,"10")

"Barb Miles" wrote:

I have a range of numbers between 1 and 25 in 50 cells.

How could I use the countif function to look at that range of numbers for
values between 5 and 10 and count those values that meet the criteria of
between 5 and 10?

Or if there is another function to use, let me know.

Thank you.
--
Barb