Resolved >>> Subtracting from column letter

Is it possible to subtract a number from a column letter?
I'm trying to create a sheet that does some helpful calculations. In order for me to finish it without a macro i need to be able to subtract a number in a cell from a column letter.
Example F-5=A, The end i'm trying to achieve is to get a sum range to move left and right in this data set based on that number.

Any ideas?

Thanks All,

Chris

I suspect that if you describe what you ultimately want to do, we can come up with some good suggestions.

I want to be able to move a sum range left and right based on this number.

So like =SUM((F-5)7:(F-5)10), which would result in =SUM(A7:A10)

So the range would go to the left 5 columns.

That's the best example i can use to explain what i'm trying to get towards.

Here's another.

I want to be able to change the number of columns apart the numbers are that are subtracted from each other.
=(F-5)1-(F-5)6

Keeping in mind that the 5s i used would actually be a cell's value, so something like A1.

Just yell at me if i'm making no sense.

Thanks All,

Chris

Perhaps something like this:

A1: (contains the offset value)

B1: =SUM(OFFSET(F7:F10,,A1))

That formula uses F7:F10 as the base range and offsets left (neg numbers in A1) or right (pos nums in A1) and sums the referenced range.

Examples:
A1: 2
B1 sums H7:H10

A1: -2
B1 sums D7:D10

Is that something you can work with?
(See the OFFSET function in Excel Help)

Glad I could help (and thanks much for the kind words)