Indirect function to reference a named range

[tcardwell]

Hello All,

Stumped on trying to get the Indirect function to return the name of a range. The following formula works when the named range(Maintenance) is hard-coded, but the idea is to make this part of the formula dynamic.

=SUMPRODUCT(SUMIFS(PerAct,Entity,57,Date,"4/30/2015",Account,Maintenance)) (this works)

When I try:

=SUMPRODUCT(SUMIFS(PerAct,Entity,57,Date,"4/30/2015",Account,INDIRECT("A7")))

for some reason it doesn't work, however, =Indirect("A7") when typed alone into another cell returns "Maintenance".

Any help will be tremendously appreciated!

 

[tcardwell]

Dropped the double quotes around A7 and it worked as planned!!