ref error in a formula

[ASZ_Excel]

Hi Guys,

Below formula keeps on giving me REF error. I cannot figure out why, can anyone have a look at it

{sum(indirect("'[benchmark 04.30 project.xlsx]" & $H7&" '!M$6"))}

thanks

 

[DanteAmor]

Hi Guys,

Below formula keeps on giving me REF error. I cannot figure out why, can anyone have a look at it

{sum(indirect("'[benchmark 04.30 project.xlsx]" & $H7&" '!M$6"))}

thanks

You have a space between quotes and apostrophe.

Should be:

{sum(indirect("'[benchmark 04.30 project.xlsx]" & $H7&"'!M$6"))}