# 3.140 FAQ-837 How to group data into bins and sum up the data of each bins respectively?

Last Update: 9/21/2017

If you want to group your data into bins and calculate the sum of data in each bin respectively, as a workaround, you can group the data by setting group numbers for data at first, and then do statistics on groups.

It is supposed that there is a data that is from 1 to 20 in Column A, you can follow the steps as below:

1. Add a new column Column B, and enter the values of bin ends in Column B.
For example, if you want to group data into the bins that are [0, 5), [5, 10), [10, 15) and [15, 20), you can enter 0, 5, 10, 15 and 20 in each row of Column B.
2. Add a new column Column C and set its long name to GroupNumber.
3. Highlight Column C, and then right click to select Set Column Values… in context menu to launch Set Value dialog.
4. Enter Index(col(A),col(B),1) in the Column Formula edit box.