Bins Size quantities

[Aland2929]

I have used Data Analysis (Histogram) to calculate the frequency of different bin sizes. I now need to calculate the quantities that relate to the bin sizes? I have attached a sample file.

Thanks in advance

[Aland2929]

I have tried to figure this out but have not been able to. Is this possible?

[FDibbins]

what your your expected answer/s be, and how would you get that?

[djapigo]

Aland, I'm confused with what you want to see... can you give an example of results?

For some reason, I keep thinking "why don't you just use multiplication"? But I'm sure it's more complicated than that...

[Aland2929]

Sorry, the workbook was a bit confusing. I have removed the blanks and sorted column A in descending order and calculated 2 quantities. I hope this makes sense. I have attached a new sample file.
Thanks in advance

[Ace_XL]

In H14

=SUMPRODUCT(--($A$2:$A$639>F13),--($A$2:$A$639<F14),$A$2:$A$639)

Copy up. Does that work for you?

[Aland2929]

I had to change the formula in cell H2 (>0), but the total does not add up to the total in column A?

[Ace_XL]

Change to

=SUMPRODUCT(--($A$2:$A$639>F13),--($A$2:$A$639<=F14),$A$2:$A$639)

in H14

[Aland2929]

Thank you very much. Works perfectly. Please explain the: --?

[Ace_XL]

Please explain the: --?

Well explained here

http://www.xldynamic.com/source/xld....CT.html#format