G
Guest
I am working with a formula which references a sheet in another workbook:
=SUM('Q:\ServCtr\ACCT\[ACCT Validation.xls]AL'!$D$290:$D$318)
This works, however the "AL" above refers to Alabama and I need to use this
formula for each state which has a separate page. I have a list of all state
abbreviations in my current workbook and would simply like to reference this
by cell instead of using a different state abbreviation on each line. I've
attempted many variations of the following formula (where B7 is the cell
which contains the abbreviation AL)...but no luck.
=SUM(INDIRECT('Q:\ServCtr\ACCT\[ACCT Validation.xls]"&B7&"'!$D$290:$D$318))
Any suggestions would be greatly appreciated! Thanks!
=SUM('Q:\ServCtr\ACCT\[ACCT Validation.xls]AL'!$D$290:$D$318)
This works, however the "AL" above refers to Alabama and I need to use this
formula for each state which has a separate page. I have a list of all state
abbreviations in my current workbook and would simply like to reference this
by cell instead of using a different state abbreviation on each line. I've
attempted many variations of the following formula (where B7 is the cell
which contains the abbreviation AL)...but no luck.
=SUM(INDIRECT('Q:\ServCtr\ACCT\[ACCT Validation.xls]"&B7&"'!$D$290:$D$318))
Any suggestions would be greatly appreciated! Thanks!