View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hi
 
Posts: n/a
Default 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.