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.

  • Try

    =INDIRECT("SUMIF(Master!B:B, E6,"&N13&")")

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!