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

#### ExcelNinjaWannaBe

##### New Member
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.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### VoG

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

#### facethegod

##### Well-known Member
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

Code:
``=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

##### New Member
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?

Replies
3
Views
158
Replies
2
Views
126
Replies
4
Views
531
Replies
5
Views
201
Replies
9
Views
147

1,191,609
Messages
5,987,648
Members
440,104
Latest member
thigarette

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back