Creating a List Based on Sum of Values

[ramaye]

Hello All,

looking for some help on a project i am doing. What I am needing to do is have excel sum up the values in different columns to not exceed a pre-determined value. Then have it list out the corresponding data.

For example:
I want it to add the values in column G until they reach the value in cell C13. Then reference column E to tell me the first cell and last cell.
So in the attached image it the desired result would be
A - 11/12 to A - 15/16
A - 17/18 to A - 23/24
A - 25/26 to A - 29/30
A - 31/32 to A - 35/36
A - 37/38 to A - 41/24

 

[CA_Punit]

Can you explain in detail.

I want it to add the values in column G until they reach the value in cell C13

From where it should reach C13 etc etc

 

[Fluff]

Cross posted Creating a List Based on Sum of Values

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[ramaye]

Sorry I was not aware the fourms were linked. I am in a time crunch to get this completed. Here is the link to the other post Creating a List Based on Sum of Values

 

[ramaye]

Can you explain in detail.



From where it should reach C13 etc etc

So I am adding up values down column G (G10 to G59 to be exact). The sum can not go over the value in C13. So that would be the breaking point and the next series would start.

It let me post a photo this time