Forum Discussion
Help needed for understanding with structured reference
It depends on what you are trying to do, i.e.
If you're trying to get a range:
If you're trying to do an equation:
so what are you trying to do? show the desired result
here a sample file and what i wanna do
That is not a problem with structured references. If you try it with regular cell references you get a #VALUE! error. The union operator only works in certain functions.
And you are giving conflicting information: In G2 you want Sales and Goal, in N2:O2 you show Sales and % of Goal.
Support page describes union with this example:
and it does not work, I did a search for the word union:
So as it is currently described in the support page:
https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e
it does not seem to work as "described" in the support page.
Union works with structured reference exactly the same way as with non-structured references.
Simplest case of using union
=SUM(C2:C7,E2:E7) or =SUM(DeptSales[Sales Amount],DeptSales[Commission Amount])Not sure where union is explained in documentation, but you may find in blogs. Perhaps oldest one is
Union and Intersect – Daily Dose of Excel
Another story is that only few functions support using of union - SUM(), COUNTA(), SMALL(), MAX() and like.
Adrira's idea was to have a desired result as shown in a pivot table:
only using structured table reference
