Forum Discussion
Help needed for understanding with structured reference
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.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/structured-reference-union-does-not-work-as/0f78fd96-1323-4a2a-aaaa-344586fa1d2a?messageId=8ab93572-d5c5-4e95-9f02-fede5e58e200
It's a different story when Union reference is wrapped within another excel function, however I am talking about how it is described in the support page. Which is by itself as if referencing a couple of range reference to induce a spilled range consisting of the 2 different ranges that comprises of the Union Structured reference. The user inquiry is very specific about
"understanding how it is described in the support page"