Syntax help - SUMIF Formula

hi there,

I have a formula in a cell:

=SUMIF(Master!B:B, E6,N13)

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.

Thanks for your help.
I was getting a #REF error, so I decided to write the SUMIF as a VBA formula instead and it seems to work better that way.

I got my info from here in case anyone else has this issue: https://www.exceldome.com/solutions/excel-sumif-function/