ExcelNinjaWannaBe
New Member
- Joined
- Aug 7, 2007
- Messages
- 6
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.
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.