Use SUMIF? Sum of Column According to #in Another Column

[ExcelNinjaWannaBe]

I am trying to find the sum of numbers that are in Column B that correspond to certain buckets of numbers from Column A. For example:

Column A--------Column B
# of items---------Size
548----------------3,000
1,500--------------2,549
22-----------------10,865

I want to separate the numbers from Column A into buckets in increments of 100 (i.e., 0-100, 101-200, etc.). Then I would like to find the sum of the sizes of each of the items in the 100-# buckets. So far, I have used dsum to find the sum of the # of items in each bucket, but I am lost as to how to find the corresponding sizes' sums. Thanks for your help! Let me know if I need to explain more clearly.

 

[VoG]

Have you tried the Histogram function that is available if you have the ToolPack Add-in installed.

 

[facethegod]

Suppose you want to sum the size of the elements in your 500 bucket then this wolud worK:

confirm w/ ctrl + shift + Enter, Not just Enter

=SUM((INT(A1:A6/100)=5)*B1:B6)

chage index from 5 to 1,2,3, if you want your 100,200,300 bucket... etc


HTH

 

[ExcelNinjaWannaBe]

Have you tried the Histogram function that is available if you have the ToolPack Add-in installed.

I have never used the Histogram function, but wouldn't that only give me the number count and not the sum?