ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 976
- Office Version
- 365
- 2010
- Platform
- Windows
In cell range R30 through R59 containing the values 1 through 30. (see attached image)
Cell range T30 through T59 contain various values and are sorted from low to high ( 1 through 16)
Disregard cell range V30 through V59.
Looking for calculations in cell range T30 through T59 that will do the following if possible:
The lowest value is 1 and the highest value is 16 (cell T59)
If I add the first 5 values from T30 through T34 they all contain a 1 so the total is 5
If I add the last 5 values from T55 through T59 the values are 9, 11, 12 ,12, 16 which total 60
So the the low value is 5 and the high value is 60.
If I enter the values starting with 5 and ending with 60 (5, 6, 7, 8, 9 ..... 60) in a new column I would like to know how many sets can be created.
Calculations would be in 5 increments
For example, starting in cells T30 though T34 (5 increments) they all contain the values 1 which totals 5.
In cell range T30 through T37 all contain the value 1.
The total would be 56 using the formula =combin(8,5)
So the sum 5 would total 56
The rest I'm still trying to figure out and looking for help.
Thanks in advance!!
Cell range T30 through T59 contain various values and are sorted from low to high ( 1 through 16)
Disregard cell range V30 through V59.
Looking for calculations in cell range T30 through T59 that will do the following if possible:
The lowest value is 1 and the highest value is 16 (cell T59)
If I add the first 5 values from T30 through T34 they all contain a 1 so the total is 5
If I add the last 5 values from T55 through T59 the values are 9, 11, 12 ,12, 16 which total 60
So the the low value is 5 and the high value is 60.
If I enter the values starting with 5 and ending with 60 (5, 6, 7, 8, 9 ..... 60) in a new column I would like to know how many sets can be created.
Calculations would be in 5 increments
For example, starting in cells T30 though T34 (5 increments) they all contain the values 1 which totals 5.
In cell range T30 through T37 all contain the value 1.
The total would be 56 using the formula =combin(8,5)
So the sum 5 would total 56
The rest I'm still trying to figure out and looking for help.
Thanks in advance!!