I need help. I want to drag the following formula down a column and change the last column reference as I drag it down the column. Can some one help me write a formula so the last column reference advances one column to the right as I drag it down the column I am copying the info please? Here is the formula I am writing and here is how I want it to advance. I highlighted the desired changes in red.



I'm a novice when it comes to formulas, so take it easy on me.

=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,('Volume Budget'!A:A))

=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,('Volume Budget'!B:B))


=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,('Volume Budget'!C:C))


And so on.....

Thank you for your help.

Try:
=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,(OFFSET('Volume Budget'!A:A,,ROW()-1)))
where the final '1' is equal to your starting row#

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]