=SUMIF(A2:A12,"<=10",B2:B12) assuming "distance" is in A1

--
Ian
--
"Hi" wrote in message
...
distance count of distance
5 59
6 6
7 23
9 3
10 76
15 16
20 21
22 5
24 1
25 127
26 4

like this i have the data in two columns, now i want to get the frequency,
for example 0-10 distance range i need the toal sum of the count distance.