Indirectly referencing table column title (from another cell) in formula

[alfiedee]

I've created a table (let's be original and call it "Table"), with various columns representing tags that are associated with each row item (Tag1, Tag2, etc.). Those columns would contain "1" if that row is associated with that particular tag.

On a different sheet, I've put together a report that also contains those tag titles, and it would summarize certain values from the table for rows that are associated with the tag.

E.g. (on the Report sheet)
Cell A1: "Tag1"
Cell B1: =SUMIF(Table[Value],Table[Tag1],1)
Cell A2: "Tag2"
Cell B2: =SUMIF(Table[Value],Table[Tag2],1)
etc.

I'd like to reference the tag label from the actual cells in A1, A2, etc. rather than manually type each tag's labels throughout the formulae (the actual formula is a longer SUMIFS).
I've tried:
Cell B2: =SUMIF(Table[Value],Table[INDIRECT(A1)],1)
But that didn't seem to work.

Any advice?

Thanks in advance

 

[Fluff]

It would need to be

=SUMIF(Table[Value],INDIRECT("Table["&A1&"]"),1)

 

[Fluff]

Another option without using the dreaded Indirect function is

=SUMIF(Table[Value],index(Table,,match(A1,Table[#Headers],0)),1)

 

[alfiedee]

Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback.
I would also strongly advise using the formula in post#3 rather than using INDIRECT. INDIRECT – Excel’s Most Evil Function

 

[alfiedee]

Gotcha, thanks. I was actually wondering why INDIRECT has such a bad reputation

 

[Fluff]

My pleasure.