#### MikeGraves

##### New Member

- Joined
- Sep 2, 2014

- Messages
- 3

Can someone please tell me how to:

a) I have 40 numbers (percentages)

b) I need every outcome of these 40 numbers (added together) in groups of 6

(so example, 1+2+3+4+5+6, 1+2+3+4+5+7..... to the last potential sequence i guess, 35+36+37+38+39+40)

So example

1 0.100

2 0.214

3. 0.117

...

40 0.225

What is important for me is to have these located within a range.

i.e. High 1.5 Low 1.2 (i can search this , its no issue, index match function will do)

but i need the macro or formula to create it without me doing 1.8m formulas.

Then be able to know, ok

1 3 4 21 22 39 (in range) (obviously the numbers are added)

3 24 16 12 18 40 (in range) (obviously the numbers are added)

Is there some simple (i.e. non genius solution) any one can share. I have read dozens of posts, and while some touch upon this subject, its all different.

Id really really appreciate some help/guidance. Thanks everyone.