hi all i am trying to set up a cell that will countif a number in the range is greater than 5 BUT less than 59 i know how to do the first part but not the second. any help would be greatly appreciated
Posts by dvd112411


thanks rolls that seems to work just fine

i'm sorry but that does not seem to work

i think the way to do it would be to pick a cell under the numbers you want to avg. hit sum pick your range of cells you want to count then put / and the number of rows you have let me know if that works for you

i am trying to make a cell countif the number in the range is greater than 5 but less then 10. i then want another cell to countif the number is10 or greater but less than 15. and so on. how do i enter that ? thanks