ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do get the frequency in 2 columns (https://www.excelbanter.com/excel-worksheet-functions/59685-how-do-get-frequency-2-columns.html)

Hi

how do get the frequency in 2 columns
 
i have the data from pivot table, for example i have the two columns of
Travel Distance Total
10 5
15 9
20 36
22 5
25 263
26 4
27 6
28 6
30 23
32 4
33 2
35 10
38 1
40 5
45 5
from this data i want to get the frequency of ranges is like that
0 10
10 25
25 50
50 100
100 300
i want to get the sum from total column,for example from 10 to 25 with in
that range from the total distance i need the sum from total column.


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com