Probability Bands

[clattenburg cake]

I have the probability of 12 outcomes (the number of games where both teams score in a hockey match) in a table in excel.

Event Probability
0 0.0001
1 0.0014
2 0.0089
3 0.0341
4 0.0885
5 0.1631
6 0.2190
7 0.2161
8 0.1555
9 0.0795
10 0.0275
11 0.0057
12 0.0006



I am trying to create a list on one column for bands (which will be selected for a drop down menu). This is what the column will show:

For instance, bands of 2 would be 0-2, 3-4, 5-6... 11-12; bands of 3 would be 0-3,4-6,7-9, 10-12, bands of 4 would be 0-4, 5-8, 9-12. When it gets to bands of 5 I would like it to be less than 5, more than 5 and so on until 8. The column immediately to the right will have the sum of the probabilities (e.g. bands 0 to 2 = 0.0001+0.0014+0.0089, bands 5 to 6= 0.1631+0.2190 etc.)


I can do this using simple lookups which work fine, however I believe there must be a more general way of doing it. Can anybody help please?