FREQUENCY function with total?

B

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
 
J

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.
 
Top