Column label ref in formula

[Joe Blow]

Hi,

I am using this formula in one spreadsheet to sum several columns in a
different spreadsheet (06SO_LOG.xls) tab (MAR). I call this formula
for each month of the year. I also have the months as column labels
and would like the formula below to reference the month label so I
don't have to edit each formula for the corresponding month. Is there
a way to do this?

=SUM(IF('[06SO_LOG.xls]MAR 2006'!$C$6:$C$200=$A5,'[06SO_LOG.xls]MAR
2006'!$K$6:$K$200,0),IF('[06SO_LOG.xls]MAR
2006'!$C$6:$C$200=$A5,'[06SO_LOG.xls]MAR
2006'!$L$6:$L$200,0),IF('[06SO_LOG.xls]MAR
2006'!$C$6:$C$200=$A5,'[06SO_LOG.xls]MAR 2006'!$M$6:$M$200,0))

Thx,
Joe

 

[Joe Blow]

Hi,

I am using this formula in one spreadsheet to sum several columns in a
different spreadsheet (06SO_LOG.xls) tab (MAR). I call this formula
for each month of the year. I also have the months as column labels
and would like the formula below to reference the month label so I
don't have to edit each formula for the corresponding month. Is there
a way to do this?

=SUM(IF('[06SO_LOG.xls]MAR 2006'!$C$6:$C$200=$A5,'[06SO_LOG.xls]MAR
2006'!$K$6:$K$200,0),IF('[06SO_LOG.xls]MAR
2006'!$C$6:$C$200=$A5,'[06SO_LOG.xls]MAR
2006'!$L$6:$L$200,0),IF('[06SO_LOG.xls]MAR
2006'!$C$6:$C$200=$A5,'[06SO_LOG.xls]MAR 2006'!$M$6:$M$200,0))

Thx,
Joe

I guess I should have said that I want to use the month label in the
formula instead of explicitly using MAR

In example MAR is in D1, is there a way to use the D! reference in the
formula above?

Thx,
Joe