Get Column Number in a given range

Hello,

I have some difficulty in solving a formula for COLUMNS. I want to get the equivalent number for the last column in a given range.

This is my table looks like:
[TABLE="border: 1, cellpadding: 1, width: 500"]

[tr]

[td]

A

[/td]

[td]

B

[/td]

[td]

C

[/td]

[/tr]

[tr]

[td]

Column where to Start

[/td]

[td]

Column where to End

[/td]

[td]

Formula to get the number of End columns

[/td]

[/tr]

[tr]

[td]

G

[/td]

[td]

I

[/td]

[td][/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[/TABLE]

I know the formula is =COLUMNS(G:I) and the result is 3. How do i write the COLUMNS formula that instead of typing G:I, it will locate the stated value in column A and column B.

I tried this formula: =COLUMNS(A3&":"&B3) but the result is #VALUE!.

Anybody knows if this is possible with formula?

Thanks in advance.

I got it right now... i just combine INDIRECT functions..