Posts by kfree

    Hello. I am new to the forum and looking for help with a formula. I have a dataset formatted as table "Historical" with several columns. I have formulas with structured references, like this: =SUMIF(Historical[2011 Cat.],"Sales",Historical[Feb '11 Sales])

    I would like to instead use a reference to a list that contains all my column headings, something like this:
    =SUMIF(Historical[2011 Cat.],"Sales",Historical[A1])

    I have tried using INDIRECT but doesn't seem to work in this situation. Any ideas? Thanks in advance.