Fallen into a range

W

Wujo

My problem is how to compute how many times a number falls into the range.
For example we have ranges:
12 - 20
15 - 40
7-18.
How many times falls "13" into above ranges?
Thanks for help!!!
 
T

tjtjjtjt

What excatly do your "ranges represent"? A group of cells? If not, I'm not
sure I understand how 13 could fall into 15-40.
If you want to count occurrences of the number 13 in a range of cells:
=countif(your_range,13)

tj
 
F

Frank Kabel

Hi
not really sure what you want to test exactly. Do you want to count numbers
in a range and see how many numbers fall into one bin?
 
T

tghcogo

If column A is 12 - 20, B is 15 - 40, and C is 7 - 18

=COUNTIF(A1:A9,"=13") will return 1
=COUNTIF(B1:B26,"=13") will return 0
=COUNTIF(C1:C12,"=13") will return 1

or for a total

=COUNTIF(A1:A9,"=13")+COUNTIF(B1:B26,"=13")+COUNTIF(C1:C12,"=13")

will return the answer 2

Cheers
TGHCOG
 
Top