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.
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.
=SUMIF(A2:A12,"<=10",B2:B12) assuming "distance" is in A1
--
Ian
--
"Hi" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks