Frequency count with multiplier value

Occasional Contributor

I would like to tabulate the frequency of Column B values into Column C bins while also taking into account the factor in Column A.  Any suggestion to obtain the desired frequency in Column E without many manual insert row/copy/paste steps would be appreciated.  The file is uploaded too.  Thanks.

NumberLengthBinFrequencyDesired frequency 
11010.411 
110.510.933 
110.511.4513 
110.811.91125 
111 0 ←extras
411 2042←sum
411    
311    
111.2    
211.5    
111.5    
211.5    
311.5    
511.5    
311.5    
511.5    
111.6    
111.6    
111.6    
111.7    
42    ←sum
3 Replies

@scheij 

See attached file.

 

@scheij As a variant

=SUMPRODUCT($A$2:$A$21*($B$2:$B$21<=C2)*($B$2:$B$21>=N(C1)))

in E2 and copy it down to E5.

 

See attached 

Thank you. The =SUMPRODUCT function will be very helpful for us in many applications.