I have a formula in a cell:
where N13 contains this: "Master!AL:AL"
the value in N13 is generated by a different formula (using some functions and Concatenate)
If I enter it straight in the formula, it works: = SUMIF(Master!B:B, E6, Master!AL:AL)
BUT if I point it to the cell, it doesn't work. What is the correct syntax to reference the value in N13 so the formula reads it correctly?
Thanks in advance.