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
|