i have a spreadsheet with multiple columns. One of these columns have a numeric value. I want excel to group the data based on a sum on this column. example: each line has 2 columns, one a name and one a value (which is a point).
line 1 apples 5
line 2 pears 3
line 3 grapes 4
line 4 grapes 2
line 5 apples 7
line 6 tomatoes 4
line 7 peaches 8

I want it to group my line by subtotaling every 10 points or less. so the result I am looking for is as follows:
line 1 apples 5
line 2 pears 3
line 3 grapes 2
subtotal 10

line 4 grapes 4
subtotal 4

line 5 apples 7
subtotal 7

line 6 tomatoes 1
line 7 peaches 8
subtotal 9

Any ideas?