How do I change column references when filling down a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to change column references, while filling down another column 1
Reference Formula Help 1
vlookup? 5
how do i enter the formula? 3
excel formula 1
Fill formula down for cells 74 rows apart 3
Please help me with a formula 4
Calculation needed maybe a pivot table - Thank you 2

Back
Top