INDIRECT with named range

[zJenkins]

Hi,

I'm trying to reference a named range using the indirect formula but am getting an #REF error.

=IF(cur_month>=G$12-1,SUMIFS(INDIRECT("amt_"&G13),INDIRECT("dpt_"&G13),'Rooms-0010'!$A32,INDIRECT("acct_"&G13),'Rooms-0010'!$B32),SUM(G15:G31))

cell G13 has the value of "Jan" and my named ranges are "amt_Jan", dpt_Jan, and "acct_Jan"

The formula works until I add the INDIRECT's to it.

Thank you for your help.

 

[zJenkins]

I think it has to do with the dynamic ranges...If I remove the dynamic range formula and just select a certain number of rows, the indirect function works.

 

[zJenkins]

Bump

 

[Jeffrey Mahoney]

I got the same thing on my end. You'll have to another route.

 

[zJenkins]

I got the same thing on my end. You'll have to another route.

That's too bad...

I really appreciate your time and help though, thanks!