How do I change column references when filling down a formula
 

I want to drag this formula down 12 cells (months)

='Total Commissions'!B$2
='Total Commissions'!C$2

I know that the "$" will make the Row Reference static, but how do I get the
Column Reference to change

How do I change column references when filling down a formula
 

Hi Bclancy,

one way is create a list with 1,2,3...12 in one column suppose it starts on
g1 thu G12 so

the formula could be:
=indirect(address(2,col()+g1,1,1,"Total Commissions")
and copu it down

hope this helps
Regards from Brazil
Marcelo

"bclancy12" escreveu:

I want to drag this formula down 12 cells (months)

='Total Commissions'!B$2
='Total Commissions'!C$2

I know that the "$" will make the Row Reference static, but how do I get the
Column Reference to change

How do I change column references when filling down a formula
 

I would probably use the indirect function Check help for details

=indirect("'Total commissions'!R2C"&(row()+X),1)

where X is the value needed to get the appropriate column reference in the
first equation cell

"bclancy12" wrote:

I want to drag this formula down 12 cells (months)

='Total Commissions'!B$2
='Total Commissions'!C$2

I know that the "$" will make the Row Reference static, but how do I get the
Column Reference to change

How do I change column references when filling down a formula
 

Hi

One way
=INDIRECT("'Total Commissions'!"&CHAR(ROW(66:66))&"2")

--
Regards

Roger Govier


"bclancy12" wrote in message
...
I want to drag this formula down 12 cells (months)

='Total Commissions'!B$2
='Total Commissions'!C$2

I know that the "$" will make the Row Reference static, but how do I
get the
Column Reference to change