ExcelBanter - how do get the frequency

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do get the frequency (https://www.excelbanter.com/excel-worksheet-functions/59225-how-do-get-frequency.html)

how do get the frequency

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.

Ian

how do get the frequency

=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.

All times are GMT +1. The time now is 05:14 PM.