Hello,

Can you please help me on this one?
I have this table to wicj I apply the frequency function
(=FREQUENCY(B7:B13,D7:D10) ), which is ok.

Age # of People Bin Frequency
33 6 10 0
34 25 15 1
14 9 20 2
17 6 30 1
29 16 3
20 4
35 1

Now, I want to calculate the frequency based on the number if people I have
in that age. For instance, the frequency of 15 should be 9 and not 1 (there
are 9 persons with 14 yrs of age); the freq of 20 should be 10 and so on.

How can I do it?

Than you,