Revised Question: Sum every other cell in a single row?

[cdpar]

Hi,

I was told my previous question was not clear, so I am reposting:

• I have a single row of numbers in 100 cells (A1:A100)
• I want to "Select" every other cell (Odd) to use in a formula to place in cell A150.
• Currently I add the formula "=Sum(A1, A3, A5, A7, ... A99)"

Here is my challenge: Each week the number of cells in Row A can increase or decrease by more than 20 figures.

Currently I manually edit the formula in Cell A150 by either adding or removing the cell references for the additional cells. So my new formula might be "=Sum(A1, A3, A5, A7, ... A101, A103, A105, A107, A109)"

Is there a function I can add to my formula which will automatically add or subtract the cells in the new row so that I do not have to spend my time editing the references?

Please help. I hope this is clearer.

Thanks!

Chuck


Example: SUM(A1+A3+A5+A7 ... GA1+GA3)

How can I automatically have Excel give me all of the cell addresses for every other cell in the row?

The number of cells in the row changes from week to week so I have to modify the resulting formula each week.

Thank you!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...cell-row-formula-post5178393.html#post5178393

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).