vary column

**adygelber** · 10-16-2012, 01:09 PM

Hello,

I have the following script:

Please Login or Register  to view this content.

All I want to do is to set the column as a variable in the SUM formula...practically I want to have a variable number of sums in which the column changes (ex. AB7:AB23, AC7:AC32, AD7:AD32, etc.).

Any ideas?

Thank you for your support!

**jaslake** · 10-16-2012, 02:31 PM

Hi adygelber

This MIGHT work...don't know...can't test it

Please Login or Register  to view this content.

Alternately try this

Please Login or Register  to view this content.

PS: in reading your issue again, I may well have answered a question you didn't ask...apologies.

**adygelber** · 10-17-2012, 02:45 AM

To be more clear I attached the file. As you can see the formula it's ok on AB33 because it makes the sum of the cells AB7:AB32. But in the cell AC33 I have the same formula instead of AC7:AC32 and so on for the rest of cells AD33, AE33, etc.
This is the reason why I asked to vary the column letters and to keep the number, because I want to multiply horizontally the formula.

Can you help me?

PS: The code which does not work is written in brackets "----------------------"

Thanks!

**jaslake** · 10-17-2012, 01:27 PM

Hi adygelber

Try any one of these approaches

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**adygelber** · 10-17-2012, 02:56 PM

thank you very much for your solutions.

**jaslake** · 10-17-2012, 03:09 PM

Hi adygelber

You're welcome...glad I could help. Thanks for the Rep.

You've incorrectly marked your Thread as SOLVED.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save