Adding numbers from an array into a single cell

Hi,
I have list of values(numbers) on a particular column (col. D in the xl attached) but this list varies for several scenarios. The good thing is the list of numbers are spaced at constant intervals. I'm able to capture the list of numbers into an array but struggling to add all the numbers in the list i.e., adding all the numbers stored in this array from the list into a single cell.

Could somebody please help me on how to get this done?

P.S. I need to save the list of numbers into an array.

Sorry youre going to have be a bit more specific, your attachment simply has 3 numbers in it, no explanation or anything.

Please explain exactly what youre trying to achieve and ideally, amend the attachment to show examples ie show what the data is, where you want it putting etc.

Thank you that definitely is more descriptive. Im still not understanding the question though (its Friday and my brain is already in Weekend mode!).

I understand that you need to total up all of the individual columns Benefit values however you are talking about arrays, is there some other reason you need the data in arrays or is the array just the result of a previous attempt at solving this? Im also unsure what you mean by "I'm struggling to get 'G8+G17+G26+G35' into one cell that would fit into another table."

Same here with my brain! . The reason I'm saving the values G8, G17, G26 and G35 into an array is because those tables are generated from a macro depending on the number of Use Cases (1 Use Case = 1 Table) from another sheet. And the use cases vary from sheet to sheet and I don't know how many tables will get generated from each sheet. So the only way I thought is to store the benefits from each column from each table into an array. And I need sum of the values like G8, G17, G26, G35 and so on..

"I'm struggling to get 'G8+G17+G26+G35' into one cell that would fit into another table." - This summed value will be populated in another table. If I get the sum I can manage putting it anywhere.

Hope I didn't confuse you!

Edit:

Hi jindon,
Thanks for the code but little confusing for a novice like me If you don't mind could you please look at the v2 excel I have attached and from the challenge I shared above, could you please modify the code

Thanks

Hi jindon, in my larger worksheet this is not working properly. I have attached the sheet. I need to have F98= Sum(F32, F42, F52. F62) and similarly for columns G to Y [G98= Sum(G32, G42, G52. G62).. Y98= Sum(Y32, Y42, Y52. Y62)].

Very sorry that I missed out an important part that there is another table Rows 67 to 89 and this table needs to be ignored for calculating the sums from above tables.

Could you please modify your code

Domo jindon! Let me spend sometime on this code and will get back to you if I have any confusion.

If Im reading you correctly then you dont necessarily know how many tables you're going to have and therefore cant just do a standard sum, if so then you could just use SUMIF

eg to get the total of the column G entries use the formula:

Please Login or Register  to view this content.

Which basically sums the items in column G whenever theres the word "Benefits" in column B

EDIT: To ensure your "totals" table isnt included slightly change the word Benefits in that table you could even add a trailing space or Underscore.