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
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