FREQUENCY function with total?

[bill_s1416]

I successfully used the FREQUENCY function to count the scores into fou
different bins (ie. ranges.) Now I need a total of the scores withi
each bin. How can I do that?:confused

 

[JE McGimpsey]

One way:

Say your values are in A1:A100, your bins are in B1:B4. Then

D1: =SUMPRODUCT(--($A$1:$A$10<=B1),$A$1:$A$100)
D2: =SUMPRODUCT(--($A$1:$A$10>B1),--($A$1:$A$10<=B2),$A$1:$A$100)

Copy D2 down to D4.

 

[bill_s1416]

thank you. i love sumproduct.