Hi all, I'm sure this is easy but.............
I have a range of numbers in cells ranging from 1 to 100. I know how to do a count for those greater than say 40 (COUNTIF(range),"40") and so on but how do I do the same count if I want to specify BETWEEN 40 and 50? This would also apply if I needed to do a sum of the cells fitting in this range.
Thanks in advance
I have a range of numbers in cells ranging from 1 to 100. I know how to do a count for those greater than say 40 (COUNTIF(range),"40") and so on but how do I do the same count if I want to specify BETWEEN 40 and 50? This would also apply if I needed to do a sum of the cells fitting in this range.
Thanks in advance